Getting Started

BEEM ODBC Driver

Connect Power BI, Excel, and any ODBC application to your BEEM Data Warehouse.

How it works

The BEEM ODBC Driver creates a secure connection to your BEEM Data Warehouse. You install the driver and the Power BI connector, enter your credentials, and start querying — the secure connection is handled automatically.

Power BI / Excel ──ODBC──▶ BEEM Driver ──secure tunnel──▶ BEEM Data Warehouse

Features

  • Secure connectivity — encrypted connections through a secure tunnel, no VPN required
  • Power BI integration — custom connector with DirectQuery and Import mode support
  • One installer — driver and Power BI connector together, both signed
  • Fast schema querying — optimized to load your workspace tables quickly, faster than standard ODBC drivers
  • Table caching — full table list cached in-memory to avoid repeated round-trips

Quick start

On Windows:

  1. Download and run BEEM-Setup.msi
    it installs the driver and the Power BI connector together
  2. Create a DSN with the settings from your
    BEEM warehouse configuration
  3. Open Power BI Desktop, click Get Data, search for BEEM
  4. Pick Anonymous to use the DSN's stored credentials — you're connected

On Linux, see Installation — set up manually, without
the Power BI connector. macOS is not generally available yet; email
[email protected] and we will get you set up.

Connection modes

ModeTransportDirectQueryWhen to use
DirectSecure tunnel to BEEM Data WarehouseYesDefault — real-time queries with live connection
Data APIHTTPSNoEnvironments without bastion or SSH network permissions (e.g. due to org policies)