27 Apr, 2023

How do I access BI Connector data with Power BI?


  • Minimum knowledge of how Kizeo Forms works,
  • Knowledge of BI,
  • Installation and configuration of the ODBC connector (Open DataBase Connectivity).

Launch Power BI.

From the home page, click Get Data.

power bi get data

In (1), enter odbc, select “All” and then ODBC in (2), then click Connect (3).

power bi odbcbi connection

Select the name of your BI connection. In our example, it is: BI Connection. If your data source is not there, click on the highlighted arrow and select it from the list. Then click OK.

data source name

The first time you log in, you will be asked to enter your username (4) and password (5).

Once you have entered your login information, click on Login (6).

odbc login

This will take you to the list of your forms.

By clicking on the name of your database (7), the list of your forms appears.

list of forms

Each form appears in a view and each table of the form in a view TableName.

All you have to do is select the items you want to import.

select items to import


Go digital today!

Create an account to test the Kizeo Forms App Free of charge for 15 days !

We are available to answer your questions, suggestions, remarks, etc
Would you like to subscribe to our Newsletter?