There are four methods for connecting Power BI to Amazon Trino.
- Power BI Desktop - ODBC. Supports
AWS Profile,AWS IAM Credentials,Azure ADandOktaauthentication. ODBC data source must be created. Data is imported and must be refreshed for updates. - Power BI Desktop - Custom Connector - Import Mode. Supports
AWS ProfileandAWS IAM Credentialsonly. ODBC data sources do not need to be created. Data is imported and must be refreshed for updates. - Power BI Desktop - Custom Connector - Direct Query. Supports
AWS ProfileandAWS IAM Credentialsonly. ODBC data sources do not need to be created. Queries are live and only return the results, all data does not need to be imported. - Power BI Service. Using the
On-premises data gateway, share reports created from Power BI Desktop on the web.