Skip to content

Latest commit

 

History

History
31 lines (17 loc) · 1.62 KB

powerbi.md

File metadata and controls

31 lines (17 loc) · 1.62 KB
description
Produce reports and dashboards with Power BI using a PowerQuery template

Power BI

The OECD has developed a plugin to connect an SDMX data source directly to Power BI. It can be loaded when adding "an alternate data source" in PowerBI.

SDMX Plugin

To import a dataset you will need the API query corresponding to the data to be imported using the Data Explorer as explained here.

Then you can create a new data source in Power BI: Data > Get Data > SDMX. For importation mode, you can choose between labels only, codes only or both. (Official plugin documentation)

Plugin configuration window

When the data is imported you can transform it with Power Query ("Transform Data" button) to remove useless columns, clean some fields or anything else.

Imported Data

The next screenshot shows a Power Query with the previously imported data, transformed with some steps.

Data transformations with Power Query

Finally, your data is now imported and transformed, you can use it to do some visualisations.

Visualisation Example

NOTE: Because this plugin is free and open source, its code is publicly available in this repository.