Power BI (ODBC) - Connecting to IOMETE
If you need to connect to the default Spark Catalog, and work with Iceberg and Metastore tables, please refer to Power BI documentation. However, if you need to connect to an additional Spark Catalog, you must use the ODBC driver.
This guide will show you how to connect Power BI to IOMETE using the ODBC driver.
Let’s get started.
Create ODBC Data Source
First, you need to create an ODBC Data Source. Go to the Windows search bar and type ODBC Data Sources
and click on the ODBC Data Sources (64-bit)
.
This will open the ODBC Data Source Administrator.
![ODBC Data Sources | IOMETE](/resources/assets/images/odbc-panel-77515dfc77ea4d27556c213e7ddfc860.png)
![ODBC Data Sources | IOMETE](/resources/assets/images/odbc-panel-77515dfc77ea4d27556c213e7ddfc860.png)
Click on the User DSN
tab and then click on the Add
button. Choose the "Simba Spark ODBC Driver" from the list of drivers and click Finish
.
If you don't see the driver in the list, you can download it from the Simba website or contact us for assistance.
![Simba Spark ODBC Driver Select | IOMETE](/resources/assets/images/odbc-driver-select-73fd8a94024b3ca80a5697d0db4123f4.png)
![Simba Spark ODBC Driver Select | IOMETE](/resources/assets/images/odbc-driver-select-73fd8a94024b3ca80a5697d0db4123f4.png)
Data Source Details
Please refer to the IOMETE Platform to get the connection details. Go to the Lakehouse you want to connect and open Power BI tab in the Connections section.
![IOMETE lakehouse connection details | IOMETE](/resources/assets/images/iolake-6c5b9305570748fe52c7a50827ed1499.png)
![IOMETE lakehouse connection details | IOMETE](/resources/assets/images/iolake-6c5b9305570748fe52c7a50827ed1499.png)
Now, fill in the connection details in the ODBC Data Source Administrator as shown below.
![ODBC Connection Details | IOMETE](/resources/assets/images/odbc-props-3327c16f1a0c9af125a0920e1085197f.png)
![ODBC Connection Details | IOMETE](/resources/assets/images/odbc-props-3327c16f1a0c9af125a0920e1085197f.png)
Optionally, you can click on the Advanced
button and add additional properties.
![ODBC Connection Details 2 | IOMETE](/resources/assets/images/odbc-advanced-props-7897e05799e177d01d01b88bb92306b1.png)
![ODBC Connection Details 2 | IOMETE](/resources/assets/images/odbc-advanced-props-7897e05799e177d01d01b88bb92306b1.png)
Finally, click on the Test
button to verify the connection. If everything is correct, you will see a success message.
![ODBC Test Connection | IOMETE](/resources/assets/images/odbc-test-7acbf8777abca5f67d595f544539f857.png)
![ODBC Test Connection | IOMETE](/resources/assets/images/odbc-test-7acbf8777abca5f67d595f544539f857.png)
Connecting Power BI
Click “Get Data” from the menu and select ODBC
as a data source.
![Power BI data source | IOMETE](/resources/assets/images/pb-data-source-3a467c93da7ee5aea1b7a69b458cf0db.png)
![Power BI data source | IOMETE](/resources/assets/images/pb-data-source-3a467c93da7ee5aea1b7a69b458cf0db.png)
Then choose the ODBC Data Source you created and click Connect
.
![Power BI data source name | IOMETE](/resources/assets/images/pb-source-name-30451616d5dce516a7c3fbc73345a3c5.png)
![Power BI data source name | IOMETE](/resources/assets/images/pb-source-name-30451616d5dce516a7c3fbc73345a3c5.png)
After clicking the OK
button, you will be directed to an authentication page where you can establish a connection and input your username and password.
You will need to create a Personal Access Token and use as the password.
![Power BI auth | IOMETE](/resources/assets/images/pb-auth-bb3966ca7a7d6c204258227b673ce21b.png)
![Power BI auth | IOMETE](/resources/assets/images/pb-auth-bb3966ca7a7d6c204258227b673ce21b.png)
Now in the next step, you will see your databases and tables. Select the tables you want to use in Power BI.
![Power BI auth | IOMETE](/resources/assets/images/pb-schema-134b2a87fae4424888aa86e68f3e45d2.png)
![Power BI auth | IOMETE](/resources/assets/images/pb-schema-134b2a87fae4424888aa86e68f3e45d2.png)
You will have to wait a couple of minutes before Power BI will load the data sets.
Congratulations, you have successfully connected Power BI to IOMETE.
From this point, you can create, save and publish your reports. You can learn how to create dashboards and detailed visualizations with Power BI resources.
Thanks.