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
Download the provided Power BI template (
.pbit
) file.Open Power BI Desktop.
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:
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.
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.
Enter both Workspace ID and Dataflow ID when prompted in Power BI Desktop.
Click Load to apply the parameters.
Step 3: Authenticate and Refresh Data
If prompted, sign in using your Microsoft work account with access to the specified workspace.
Choose Organizational account as the authentication method.
Click Apply, then Close & Load.
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.