Dremio Power BI integration requires:
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 theClient Tools
pane of theSupport Settings
page and with a new REST API endpoint.
Click Get Data, choose Database on the left and select Dremio.
Enter the IP address for one of the coordinator nodes in your Dremio cluster and select the DirectQuery option.
Enter your Dremio username and password.
Select the datasets you want to analyze and Load.
Your Dremio datasets are now ready to use in Power BI.
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.