How to import data from UNdata or similar data banks

[Anonymous]

Hello everyone, 

I started using PowerBi for my work 3 month ago. I started connecting to data from the WorldBank (all is working great). However,  now i'm stuck because I can not import data from UNdata, because they use SDMX API.  I read a lot about it, and found out that there's currently no SMDX connector in PowerBI. But I also found out on this forum that there's a "hard way" to do it (connect to data in SDMX) and make it work. 

Could someone please explain to me how can I have data from UNdata, in a user friendly shape? 

Thanks a lot for your help, 

Thomas.  

[amitchandak]

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

https://community.powerbi.com/t5/Desktop/API-JSON-link-issue/td-p/112276

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

[Anonymous]

Hi,

Thanks for your help, I already saw these topics but it doesn't really helped me because the websites in these topics already have a SDMX-JSON option, which UNdata doesn't have. 

They provide different manner to connect to their datas, but I can't make it work in PowerBI. For example they also provide these kind of link to their data : https://data.un.org/ws/rest/data/UIS,DF_UNData_UIS,1.1/.SLE_0....../ALL/?detail=full&dimensionAtObse...

Is it possible to use this link in PBI in order to have a userfriendly table to work with? I tried but I only had errors... I'm sorry but I'm still learning.

Thanks for the help,

Kind Regards, 

Thomas

[ThomasJason]

Hi 
Are you solving this problem because I'm facing the same thing?