Microsoft PowerBI

Open

JDBC to Power BI first requires the JDBC to ODBC using ZappySys to be installed.

Download Power BI

Click Get Data

Open

Search for the ODBC connector and click Connect

Select the ODBC data source you created

A. Click OK and view all the available tables we expose to the navigator.

OR

B. Expand the Advanced table and provide a custom query

On the Windows tab select the Use my current credentials

Click Connect

Select the table or tables you which to import

Click Load

Your data should now be available to view in Power BI