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.
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.