Power BI Desktop ​

Create a DSN linked to an Indexima Cluster ​

ODBC-Create a DSN linked to Indexima Engine

Connecting to an Indexima cluster using 'MS PowerBI' ​

a. Choose an Indexima source ​

  • Select the icon "Get Data". A list of data-sources will appear.
  • Start to type out "Indexima" in the search box and the INDEXIMA connector appears. Select it and click on the "Connect" button.

b. Skip Warning ​

Power BI may display a dialog box. Tick "Don't warn me again" and press continue.

c. Fill in the connection information ​

  • DSN Connected: Copy/paste the DSN name you've created in the previous step
  • Indexima JDBC Port Number: Enter any value (This field is not used for DSN connection)
  • ODBC Driver: Leave it blank
  • Data connectivity Mode: Make sure you select DirectQuery

Press the OK button.

d. Enter Credentials ​

Enter the INDEXIMA credentials and click on the Connect button.

e. Select Tables or views ​

MS Power BI opens a window to browse and select tables. Once a table is selected, the content of the table is displayed on the right panel as shown below:

Click on the Load button.

f. Design report ​

Now you are able to design your own report.