Power BI Connector

The BEEM Power BI connector provides a native Get Data experience with DirectQuery and Import mode support.

Prerequisites

• BEEM ODBC Driver installed on the same machine
• A backend ODBC driver (Amazon Redshift or PostgreSQL) installed
• Power BI Desktop

Install the connector

1. Download BEEM.mez from the latest release

2. Copy to the custom connectors folder:

   %USERPROFILE%\Documents\Power BI Desktop\Custom Connectors\

   Create the folder if it doesn't exist.

3. In Power BI Desktop, go to File > Options and settings > Options > Security > Data Extensions and select Allow any extension to load without warning

4. Restart Power BI Desktop

Connect to your data

1. Click Get Data
2. Search for BEEM and select BEEM Platform
3. Choose DirectQuery or Import
4. Enter your username and password
5. Click Connect

The navigator shows your workspace tables. Expand a schema to see its tables and views.

DirectQuery vs Import

Gateway deployment

For scheduled refresh in Power BI Service (cloud), the BEEM ODBC Driver must be installed on the On-Premises Data Gateway machine:

1. Install the ODBC driver on the gateway machine (see Windows installation)
2. Create a System DSN with the connection details
3. Install BEEM.mez in the gateway's custom connectors folder:

   C:\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors\

4. Restart the gateway service
5. In Power BI Service, configure the data source under Manage gateways using the DSN