Microsoft Power BI Desktop
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
Open Power BI.
You can launch Microsoft Power BI by clicking an icon on the Client toolbar on the Dremio
Datasetspage. 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 Toolspane of the
Support Settingspage 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.