Exercise2_​SHARED-DataScreening2026

Invoice data:
https://www.lappeenranta.fi/fi/Palvelut/Paatoksenteko-ja-talous/Kaupunkitutkimus/Avoin-data/Data-aineistot/Kaupungin-ostolaskut
Licence: CC-BY
Supplier data: Amadeus (via LUT library)

[OPTIONAL INTEGRATION ] Power BI interface for web reporting.
The node send the datatable to Power Bi Cloud -platform where custom reports and appplication can be deployed. Note! Each time you close the Knime / connection, you MUST also reset the authentication node. (Right click node -> Reset OR Select node -> Press F8)






WARNING! You must double-check that your data DO NOT contain any sensitive information that cannot be transferred, stored, published or other ways handeled in the public clouds. Therefore, check first the data manegent guideline of your organisation and General Data Protection Regulation (GDPR) rules and any other possible regulations for information management to assure legal compliance of the intented operation. The owner of the user account applied in the authentication phase is always reponsible for actions violating given quidelines, service agreement or legislation.

Manually upload .CSV data to Power BI app. (https://app.powerbi.com/)

• Set ; to column delimitter.

• Use utf-8 encoding.

Use this approach in 4th period project work because Microsoft authentication (below) may not work with student@lut accounts. After the file is created.

1. Go to Power BI --> Home --> New report

2. Get data --> Drag&Drop file (Created by csv writer) --> Next

3. Select table --> Press create report --> Name for report

4. Go to My Workspace --> Stored data / Semantic model --> Click three dots --> Create Report

5. Start visualize data