Forum Discussion
How to get data from API Query with SDMX link?
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 ,
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.
2 Replies
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.
Were you able to do it?