How to get data from API Query with SDMX link?

[Anonymous]

Hello guys,

I'm pretty new getting Data from API, so it would be nice if you could give me a little hand here, please.

I have to get data from this link, where it already gives me a Query URL in SDMX.

https://ilostat.ilo.org/data/sdmx-query-builder/

But I couldn't find any topic that explain how to get data from a SDMX Query.

What steps should I take?

Copying this URL and pasting on Get Data -> Web it doesn't work well, even if I drill down.

Regards,

Lucas Padre

[Anonymous]

Were you able to do it?

I have the same issue, in my case, with this url:
http://data.uis.unesco.org/RestSDMX/sdmx.ashx/GetData/NATMON_DS/OFST_1_CP+OFST_1_F_CP+OFST_1_M_CP+OF...

I get the schema and other things but I haven't managed to get the data...
I'd appreciate any help!

[v-yuta-msft · Accepted solution]

@Anonymous ,

Currently power bi doesn't have built-in SDMX connector. Please vote for idea below:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13060662-sdmx-connection

However, the workaround exists, you can use json api, please refer to similar cases below:

https://community.powerbi.com/t5/Desktop/Get-data-using-API-link-to-OED-data/td-p/242333

https://community.powerbi.com/t5/Desktop/Import-Data-from-OECD-website/td-p/496287

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.