Skip to main content

Octo Power Query for Power BI

OctoMesh provides a Power BI add-in that allows you to import GraphQL queries directly into Power BI.

Installation​

Prerequisites​

  • Windows machine
  • Power BI installed
  • Administrator privileges

Download​

The Octo Power Query archive contains the connector and installation scripts.

To download the .zip archive:

  • Download the Octo Power Query connector here.

Installation Steps​

  1. Locate the downloaded octo-power-query.zip file.
  2. Unpack the archive.
  3. Open the unpacked folder and run installConnector.bat.
  4. Windows SmartScreen may block the script—click More info → Run anyway.
  5. When asked for the Permission for the PowerShell, click yes.
  6. A PowerShell window will open and complete the installation process.

Getting Started​

Once installed, follow these steps to begin using Octo Power Query:

  1. Open Power BI.
  2. Click Get data → Other sources.
  3. Search for Octo Power Query.
  4. Select the connector and click Connect.
  5. When prompted about third-party data, click Continue (you can check "Don't warn me again" if desired).
  6. Enter your meshmakers tenant and the rtId of the GraphQL query you want to import, then click OK.
  7. Click Sign in and ensure you're using a user account that has access to the specified query.
  8. If not already connected, click Connect again.
    Your GraphQL query data should now appear as a table in Power BI.

Features​

  • Query: Retrieve data using the rtId from your GraphQL endpoint.
  • Usage: Integrate GraphQL-sourced data into your Power BI dashboards.