The Exasol Microsoft Power BI Connector enables you to connect from Power BI Desktop to Exasol in Direct Query mode (classical import mode is supported as well).
The Exasol Microsoft Power BI Connector is a Certified Custom Connector now and is also shipped with Power BI desktop. The powerbi-exasol repository will contain the latest release which might contain modifications not yet included in the stable version.
- Install the Exasol ODBC driver (EXASOL_ODBC_*.msi) (if you are not sure if you shall install the 32 Bit or 64 Bit version install both versions)
- Install the current version of Power BI desktop
Use the Custom Connector from this Repository instead of the official shipped connector in Power BI Desktop
❗ The Power BI Release 2.66.5376.1681 64-bit (February 2019) contains all recent fixes of the EXASOL connector regarding unicode.
If you want to use the most current connector provided in this repository to be able to use the newest connector available, before the next official release of Power BI, please us the following instructions:
- Download Exasol.mez
- Create A directory like [Documents]\Power BI Desktop\Custom Connectors
- Copy Exasol.mez into the [Documents]\Power BI Desktop\Custom Connectors directory
- Open Power BI Desktop and lower the security level for extensions in Power BI Desktop to enable loading unsigned/uncertified connectors.
- Go to File | Options and settings | Options
- Go the Security tab
- Under Data Extensions, select Allow any extension to load without warning or validation
- Restart Power BI Desktop
- Now Power BI uses the Custom Connector for Exasol instead of the official included connector
- Choose Get Data -> Database -> Exasol
- Enter the Exasol connection string and choose Direct Query
- Enter credentials
- Select tables
- Review relational model, it's recommended to have foreign keys set in the database so Power BI can autodetect the relations
- Build fast dashboards on billions of rows in Exasol
The Exasol connector was tested successfully with the On-premises data gateway version 14.16.6808.1 (September 2018) and also supports Direct Query.
-
Install and configure the On-premises data gateway (https://powerbi.microsoft.com/en-us/gateway/ )
-
Copy the exasol.mez file to e.g. C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors
-
The Exasol connector will now be listed in the Connectors section of the On-premises data gateway GUI
- Go now to powerbi.com to create a new Exasol connection for this Gateway:
Allow custom connectors in your gateway
Create the Exasol Connection (Type Yes for Encryption)
- Now you are ready to go to publish your workbooks to powerbi.com from from Power BI Desktop. When connecting to Exasol from Power BI desktop use the exact same settings (Connection-String / Encrpytion Setting / User Credentials). When the workbook is published the connection of the gateway is then associated with this workbook.
