Skip to main content

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 week 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 – Enter your workspace and dataflow details, and you're ready to go.


Step 1: Set up the Dataflow in Microsoft Fabric

  1. Go to Data Factory in Microsoft Fabric and create a new Dataflow (Gen2).

  2. Choose Blank dataflow.

  3. Click Get data and select Blank query.

  4. Open the .pqt file provided by Cinode in a text editor.

  5. Copy all the content and paste it into the Power Query editor in Fabric.

  6. Name your query (e.g., CinodeData) and click Save.

⚠️ Important: Authenticate using your Cinode API key as described in the setup instructions.


Step 2: 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 3: 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 4: 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 5: 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.

Attachment icon
Did this answer your question?