Skip to main content
All CollectionsIntegrations & Add-OnsPower BI
Deploying the Power BI Template with Fabric Dataflow Gen2
Deploying the Power BI Template with Fabric Dataflow Gen2

How to get started consuming your Cinode data with Fabric Gen2 Dataflows.

M
Written by Mark Kantor
Updated over a month ago

Cinode's Power BI template file (.pbit) is designed to streamline the connection to your Dataflow Gen2 data in Microsoft Fabric. It eliminates the need for manual query setup, ensuring a consistent and efficient way to access pre-structured data. Key benefits include:

Pre-configured Reports & Queries – No need to build queries from scratch.
Parameter-Based Data Connection – Easily connect to your workspace without modifying queries.
Consistent Data Structure – Ensures data is pulled in a structured, reliable format.
Faster Deployment – Just enter your workspace and dataflow details, and you're ready to go.


Step 1: Open the Power BI Template File

  1. Download the provided Power BI template (.pbit) file.

  2. Open Power BI Desktop.

  3. When prompted, enter the required parameters as per below:


Step 2: Enter Parameters for Dataflow Connection

Upon opening the template, Power BI will prompt you to input the following parameters:

  • Workspace ID – The unique identifier for your Fabric workspace.

  • Dataflow ID – The unique identifier for the specific Dataflow Gen2 you are connecting to.

How to Find Your IDs:

  1. Workspace ID:

    • Navigate to your Microsoft Fabric workspace.

    • The URL structure is:

      https://app.fabric.microsoft.com/groups/{workspace-id}
    • Copy the {workspace-id} part.

  2. Dataflow ID:

    • Open your Dataflow Gen2 within the workspace.

    • The URL structure is:

      https://app.fabric.microsoft.com/groups/{workspace-id}/dataflows/{dataflow-id}
    • Copy the {dataflow-id} part.

  3. Enter both Workspace ID and Dataflow ID when prompted in Power BI Desktop.

  4. Click Load to apply the parameters.


Step 3: Authenticate and Refresh Data

  1. If prompted, sign in using your Microsoft work account with access to the specified workspace.

  2. Choose Organizational account as the authentication method.

  3. Click Apply, then Close & Load.

  4. Once the data loads, click Refresh to pull the latest data.


Step 4: Customize and Publish

  • Review the pre-built reports and modify visualizations if needed.

  • When ready, click File > Publish and select a Power BI Service workspace to deploy your report.

Did this answer your question?