description |
---|
Produce reports and dashboards with Power BI using a PowerQuery template |
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.
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)
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.
The next screenshot shows a Power Query with the previously imported data, transformed with some steps.
Finally, your data is now imported and transformed, you can use it to do some visualisations.
NOTE: Because this plugin is free and open source, its code is publicly available in this repository.