OctoMesh Connector for Power BI
OctoMesh provides a Power BI Connector that allows you to seamlessly integrate OctoMesh data into your Power BI reports and dashboards.
Deployment Scenarios
The OctoMesh Connector supports two deployment scenarios:
| Scenario | Description | Authentication |
|---|---|---|
| Power BI Desktop | Local development and report creation | OAuth2 (Interactive Login) |
| Power BI Service | Cloud publishing with scheduled refresh | Client Credentials (Service Account) |
Recommended Setup
For production use with scheduled data refresh in Power BI Service, use Client Credentials authentication with an On-premises Data Gateway.
Getting Started
Choose the guide that matches your use case:
- Desktop Installation - Install the connector for local report development
- Gateway Setup - Set up the On-premises Data Gateway for cloud refresh
- Power BI Service - Configure connections and publish reports to the cloud
- Troubleshooting - Common issues and solutions
Supported Query Types
The connector supports the following Runtime Query types:
| Query Type | Description |
|---|---|
| Simple Query | Returns individual entities with their rtId and attribute values |
| Aggregation Query | Returns aggregated results (e.g., count, sum, average) without individual rtId values |
| Grouped Aggregation Query | Returns aggregated results grouped by specified attributes |
Download
The OctoMesh PowerQuery Connector is available for download from the Download Center.