Cinode

Cinode's Power BI template file (<code>.pbit</code>) 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 &amp; 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 (<code>.pbit</code>) file.

When prompted, enter the required parameters as per below:

1. Download the provided Power BI template (<code>.pbit</code>) 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.

- Workspace ID – The unique identifier for your Fabric workspace.
- Dataflow ID – The unique identifier for the specific Dataflow Gen2 you are connecting to.

- Navigate to your Microsoft Fabric workspace.
- The URL structure is:
 https://app.fabric.microsoft.com/groups/{workspace-id}
- Copy the {workspace-id} part.

- 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.

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

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 &amp; Load.

Once the data loads, click Refresh to pull the latest 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 &amp; Load.
4. Once the data loads, click Refresh to pull the latest data.

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

When ready, click File &gt; Publish and select a Power BI Service workspace to deploy your report.

- Review the pre-built reports and modify visualizations if needed.
- When ready, click File &gt; Publish and select a Power BI Service workspace to deploy your report.

Deploying the Power BI Template with Fabric Dataflow Gen2

Step 1: Open the Power BI Template File

Step 2: Enter Parameters for Dataflow Connection

How to Find Your IDs:

Step 3: Authenticate and Refresh Data

Step 4: Customize and Publish