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:
- Download and run BEEM-Setup.msi —
it installs the driver and the Power BI connector together - Create a DSN with the settings from your
BEEM warehouse configuration - Open Power BI Desktop, click Get Data, search for BEEM
- 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
| Mode | Transport | DirectQuery | When to use |
|---|---|---|---|
| Direct | Secure tunnel to BEEM Data Warehouse | Yes | Default — real-time queries with live connection |
| Data API | HTTPS | No | Environments without bastion or SSH network permissions (e.g. due to org policies) |
Updated about 1 month ago
