Qubole’s Presto connector for Power BI allows end users to authenticate securely via an API token. Using Qubole’s connector, Power BI users can now select tables across any of these catalogs, and create and execute DAX queries across these different data sources for reporting, data exploration, and ad hoc analytics. Reports and dashboards can be published to the Power BI app cloud service and shared with a broader audience within your organization for downstream consumption and collaboration.
Currently, Qubole ODBC driver supports AWS and Azure with Blob Storage (WASB). Therefore, the Qubole Presto PowerBI Connector can only be used on AWS and Azure with Blob Storage (WASB). ODBC version 3.0 and later also support ADLS-GEN2 storage type on Azure and connectivity via Linux.
This guide describes the steps to configure Power BI for use with the Qubole Data Service in the following topics: