Summary
Instructions to use the Dremio ODBC Driver for Arrow Flight to connect from Power Bi to Dremio. This article discusses how to install and configure the ODBC driver in Windows Server, configure ODBC into the ODBC Manager in Windows, and then configure Power BI to connect to Dremio
Reported Issue
Difficulties when using the Dremio ODBC Driver for Arrow Flight to connect Power BI to a Dremio server.
Overview
- Install the Dremio ODBC Driver for Arrow Flight
- Configure the Data Source Name (DSN) for the Dremio ODBC Driver for Arrow Flight
Relevant Version
All versions
Steps to resolve
Prerequisite:
- Installed Power BI into Windows server
- Installed the ODBC Manager
Install and configure ODBC driver into ODBC Manager
Download the Arrow Flight SQL ODBC Driver from https://www.dremio.com/drivers/odbc/, then install it in the ODBC Manager on your computer.
Start the ODBC Data Source Administrator, click on the Drivers tab, and the Arrow Flight SQL ODBC Driver will display.
Create DSN
- Click on the System DSN tab.
- Click on the Add… button on the right hand side.
- In the Create New Data Source windows, choose the Arrow Flight SQL ODBC Driver.
- Click on the Finish button.
Enter your Dremio server credentials:
In the Advanced tab, set default as in the example below:
Click on Test Connection to test the ODBC connection to the Dremio server.
Connect to Dremio UI to make Dremio server is up and running.
Startup Power BI
- Click on Get data
- Click More...
In the Get Data windows
- Enter "dremio" in the text field to search for the Dremio connector
- Select Dremio Software
- Click Connect button
In the Dremio Software windows
- Enter Dremio server information
- Click on Direct Query
- Click on the OK button
In the Navigator windows
- Navigate to the data source that you want to retrieve data
For this example, We navigate to the data source of Samples.samples.dremio.com, then retrieve data from the zips.json file from Dremio.
Next Steps
Additional resources
Dremio's Documentation for using Power BI