Skip to main content

Power BI - Connecting to IOMETE

How to connect Power BI to IOMETE lakehouse platform.


Power BI & IOMETE connecting

This guide explains how to effortlessly integrate IOMETE with yet another popular BI tool: Power BI.

Let’s get started.

First, you have to add a new Data Source. Click “Get Data” from the menu and select Spark as a data source.

Power Bi get data

In the next Form, you will need to add connection details like in the screenshot below.

Power Bi spark connection details

⚠️ To fill in these values you can go to the IOMETE Platform and copy connection details from the lakehouse you are trying to connect. Switch to the HTTP tab in the Connections section and copy the “Server” parameter.

IOMETE lakehouse connection details

For protocol, select HTTP, and in Data Connectivity mode select DirectQuery

Important

You should always use DirectQuery for connectivity mode, otherwise Power BI tries to import all the data from storage directly to the Power BI machine, and it will eventually fail due to memory issues if you have a GB of data.

Now in the next step, you will see your tables and views. Note that Power BI doesn’t provide the option to choose a database, but instead it will display all the tables across all of your databases.

Select the tables and views you want to use in Power BI.

Power BI navigator

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.

Now you will see the data sources (tables/views) you have added displayed on the right side.

In this example, we created a simple pie chart to show the summary of orders amount per country.

Power BI chart

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.