Connecting from PowerBI

In this article, we will show you how to connect PowerBI to Querona.

Note

Querona emulates Microsoft SQL Server, therefore a built-in SQL Server provider is sufficient to connect to Querona.

PowerBI documentation is available in Microsoft online help.

Step 1: Open PowerBI and select Microsoft SQL Server

If you have not started the PowerBI yet, open it. Under the “Get Data” section, please select the SQL Server option.

PowerBI welcome screen

A new dialog opens.

Step 2: Enter server name taken from Querona Dashboard

Into a “Server” textbox enter the Querona server name and select a “DirectQuery” option. You can leave the “Database” textbox empty.

PowerBI enter server name

Click OK.

Step 3: Choose a database and desired tables or views

From the left menu in PowerBI choose desired tables or views and start exploring your data with PowerBI.

PowerBI choose database

Click Load.

Step 4: Choose query mode

Notice that thanks to Querona the “DirectQuery” mode is always available, so only results of your queries are transferred.

PowerBI choose query mode

Step 5: Optionally examine your data model

PowerBI examine model

Step 6: Start building your reports

PowerBI final results

That concludes the steps required to connect and use PowerBI with Querona.