Icon

Export_​to_​PowerBI

KBL: Preparing data for Spotfire

Calculating money used, assigned and remaining for each project by year, to generate a data for Spotfire reporting.

URL: KNIME Beginner's Luck (Book Homepage) http://Data with row ID as a column

Workflow: Export_to_PowerBI In this workflow we prepare data to be displayed in a report. Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year. We then export the money allocated, the money spent and the money remaining for each project each year to build a PowerBi report
Calculating money spent for each project each year
Calculating money in busget for each project each year
Calculating money remaining for each project each year
money assigned to project each year
Pivot
money used by project each year
Pivot
renaming "<year>+Sum(...)" into just "used <year>"
Column Rename (deprecated)
project name as RowID
RowID
Joiner
calculating remaining money
Remaining Money
send data to PowerBI
Send to Power BI
enaming "<year>+Sum(...)" into just "assigned <year>"
Column Rename (deprecated)
project name as RowID
RowID
Projects.txt file with path relative to "current workflow"
CSV Reader
by RowID
Sorter
Microsoft Authenticator (Deprecated)
by RowID
Sorter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2026-04-17
Last update: 2026-04-17
Created with KNIME version: v5.9.0
Tags: EducationKNIMEPressReportingAggregationPivotingSpotfire

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!