Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |