Dremio Community

Microsoft Power BI Desktop

Prerequisites

Dremio Power BI integration requires:

  • Microsoft Power BI Desktop (October 2018+) which includes Dremio as a Certified Connector
  • Install Dremio Connector.

Creating a DirectQuery connection to a Dremio Cluster

  1. Open Power BI.

    Note

    You can launch Microsoft Power BI by clicking an icon on the Client toolbar on the Dremio Datasets page. The Client toolbar lets you launch Tableau and Power BI from Dremio. Dremio administrators can configure which clients appear on the toolbar for a Dremio project in the Client Tools pane of the Support Settings page and with a new REST API endpoint.

  2. Click Get Data, choose Database on the left and select Dremio.

  3. Enter the IP address for one of the coordinator nodes in your Dremio cluster and select the DirectQuery option.

  4. Enter your Dremio username and password.

  5. Select the datasets you want to analyze and Load.

  6. Your Dremio datasets are now ready to use in Power BI.

    Changing the Hostname

    You can use the export.bi.hostname support key to change the default hostname of the SQL endpoint for generating PBIDS files. The export.bi.hostname property is available from Dremio version 13.0.0.

    To know how to set the export.bi.hostname support key, see Support Keys.