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.