A Power BI Pro license is required to access the integration.
For assistance, please contact your Customer Success Manager (CSM) or email support@cinode.com.
Why Power BI Integration?
The integration between Cinode and Microsoft Power BI offers an efficient way to manage and analyze your company's Cinode data. Generate detailed reports and gain insights into project status, resource allocation, and historical occupancy forecasts.
PowerBI enables you to link your forecasting data with time sheets and invoicing data to track important KPIs like book-to-bill ratio.
By integrating Cinode data into Power BI, you unlock valuable analytics that empower better planning and forecasting.
Harnessing Dataflows as a Power BI Source
We’re thrilled to introduce our Fabric Dataflow (Gen2) setup, distributed as a Dataflow Template, which streamlines how you connect, clean, and transform your data before it lands in Power BI. To further simplify your journey, we also offer a ready-made Power BI template—giving you a fast track to meaningful insights.
What Are Dataflows?
Dataflows are essentially self-contained data pipelines that ingest information from multiple sources, apply transformations, and make that organized data available for analytical tools like Power BI. Our Fabric Dataflow (Gen2) goes a step further by delivering improved scalability, more flexible transformations, and a simpler deployment process through a template-based approach.
Why Use a Fabric Dataflow (Gen2) as Your Power BI Source?
Centralized Data Logic
All your data transformations—like merging multiple sources, removing duplicates, or adding calculated columns—are handled in one place. This ensures every Power BI report draws from the same trusted data.
Enhanced Scalability & Performance
Fabric Dataflow (Gen2) can efficiently handle complex datasets or large volumes of data, which keeps your Power BI dashboards running smoothly.
Easy Maintenance
By distributing the Dataflow as a template, you can quickly apply uniform data transformations across your organization—saving time and reducing errors.
What’s Inside Our Dataflow Template?
Key Entities
Absences
Employees
Profile Skills
Customers & Projects
Project Status Histories
Roles & Role Skills
Role Bookings
Utilization
Transformations
Daily calendar data with holidays excluded (Swedish)
Roles transformed to daily role data
Absences transformed to daily absences
Data to track total number of days on same customer (for legal compliance)
Unification of Demanded vs Available skills on future Roles
Getting started
First make sure you have the Fabric integration endpoint up and running in our integration platform
Follow through the configuration wizard
Take note of the API-URL and API key once completed
Connecting the Dataflow to Power BI
In PowerBI online make sure you have an MS Fabric-enabled subscription assigned to your selected workspace
In your selected workspace select New Item (top left)
Select Dataflow Gen2 as DataSource
Select to create the Dataflow from attached Template
Add your ApiKey and ApiUrl parameter to the Dataflow:
When prompted for a web connection setup you can create one and leave it as anonymous (we secure your data with the API key entered in above step)
Data should now be populated from the DataFlow integration point setup further up.
You can now publish your dataflow!
Once back to the listing of your workspace you will be able to see a an animated circle moving as long as the Refresh is running.
In order to schedule your refreshes (for instance once daily) you can set it up from the Workspace list view:
and then setup your refresh schedule according to your preference.
Inspiration of what can be viewed from Cinode data
Days at the same Customer: (Uthyrningslagen)
Skills Demand vs Skill Supply:
Different Sales Performance views:
