Pre-requisites for connecting ODBC and Power BI are mentioned below:
- Download and install the latest version of Power BI and Sign in using the credential.
- Download and install the ODBC Driver(any version) that the user wants to use as a Data Source.

The steps to connect our ODBC Data source to Power BI are as follows:
1) The user has to create a view in TIBCO Data Virtualization and need to publish it as a Database under Composite Data Services.

2) Open ODBC Data Source(32-bit or 64-bit) and click on System DSN tab >> click on Add >> add the ODBC Driver that needs to be used as a Datasource.



3) Configure the DSN by providing the details and test the connection. 



4) Make sure the ODBC and Power BI should be on the same machine.

5) Once the connection of ODBC DSN is successful, open the Power BI application that had been installed in the machine.

6) Click on Get Data >> More

7) One can get the full list of Data sources that can be connected using Power BI, Search for ODBC in the search box which is in the left panel, and click on connect.



8) A pop-up window will appear as shown below. Click on the drop-down of DSN and the user will be able to see all the System DSN.

9) Choose the appropriate DSN and click on OK. Now it will ask to enter the credential as shown below:




10) Enter the credential and click on Connect. Now the user has connected to the ODBC DSN.

11) After connecting, click on Get Data >> More >> Others >> ODBC and enter connection string under the Advanced option. Enter the select statement as shown below and hit the OK button.



12) The data will be displayed and the user will be able to view the records.



13) Click on Load and drag the column from the Fields tab in Power BI and the user will be able to see the Visual Graphics of the Data.

NOTE: This will help the user to view and analyze the data in Power BI using ODBC Data Source.