Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

How to get data from UNESCO online (SDMX)?

I am trying to import data from the new UNESCO data platform: UIS Statistics (unesco.org)

I want an online connection, and for that they only offer SDMX:

unesco sdmx.JPG

I've tried several approaches and I get to see the data schema, but I haven't managed to get the data.

 

I found these two workarounds but I am not sure it's the same case because the OED also offers the Developer API export:

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

Any help would be much appreciated!

2 ACCEPTED SOLUTIONS
ImkeF
Community Champion
Community Champion

Hi @Anonymous ,

it's hidden in the navigation pane.
You have to expand the folder in order for being able to select the dataset:

image.png

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Hi @Anonymous ,

It depends on your dataset, you need to expand the table to extract the corresponding data in power query.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
ImkeF
Community Champion
Community Champion

Hello @Anonymous ,

yes, that's due to the format itself. It's basically a multidimensional format, so you have to parse it out manually.


Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

ImkeF
Community Champion
Community Champion

Hi @Anonymous ,

it's hidden in the navigation pane.
You have to expand the folder in order for being able to select the dataset:

image.png

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Anonymous
Not applicable

Thanks @ImkeF, but I still get to a step where the data seems to be splitted in multiple tables:

HoracioRek_0-1615215434609.png

I've come this far:

let
    Source = Xml.Tables(Web.Contents("http://data.uis.unesco.org/RestSDMX/sdmx.ashx/GetData/NATMON_DS/OFST_1_CP+OFST_1_F_CP+OFST_1_M_CP+OFST_AGM1_CP+OFST_AGM1_F_CP+OFST_AGM1_M_CP.AFG+ALA+ALB+DZA+ASM+AND+AGO+AIA+ATG+ARG+ARM+ABW+AUS+AUT+AZE+BHS+BHR+BGD+BRB+BLR+BEL+BLZ+BEN+BMU+BTN+BOL+BIH+BWA+BRA+VGB+BRN+BGR+BFA+BDI+KHM+CMR+CAN+CPV+CYM+CAF+TCD+ZZA+CHL+CHN+HKG+MAC+COL+COM+COG+COK+CRI+CIV+HRV+CUB+CUW+CYP+CZE+PRK+COD+DNK+DJI+DMA+DOM+ECU+EGY+SLV+GNQ+ERI+EST+SWZ+ETH+FRO+FLK+FJI+FIN+FRA+GUF+PYF+GAB+GMB+GEO+DEU+GHA+GIB+GRC+GRL+GRD+GLP+GUM+GTM+GGY+GIN+GNB+GUY+HTI+VAT+HND+HUN+ISL+IND+IDN+IRN+IRQ+IRL+IMN+ISR+ITA+JAM+JPN+JEY+JOR+KAZ+KEN+KIR+KWT+KGZ+LAO+LVA+LBN+LSO+LBR+LBY+LIE+LTU+LUX+MDG+MWI+MYS+MDV+MLI+MLT+MHL+MTQ+MRT+MUS+MYT+MEX+FSM+MCO+MNG+MNE+MSR+MAR+MOZ+MMR+NAM+NRU+NPL+NLD+ANT+NCL+NZL+NIC+NER+NGA+NIU+NFK+MKD+MNP+NOR+OMN+PAK+PLW+PSE+PAN+PNG+PRY+PER+PHL+PCN+POL+PRT+PRI+QAT+KOR+MDA+REU+ROU+RUS+RWA+SHN+KNA+LCA+SPM+VCT+BLM+MAF+WSM+SMR+STP+SAU+SEN+SRB+SYC+SLE+SGP+SXM+SVK+SVN+SLB+SOM+ZAF+SSD+ESP+LKA+SDN+XDN+SUR+SJM+SWE+CHE+SYR+TJK+THA+TLS+TGO+TKL+TON+TTO+TUN+TUR+TKM+TCA+TUV+UGA+UKR+ARE+GBR+TZA+USA+VIR+URY+UZB+VUT+VEN+VNM+WLF+ESH+YEM+ZMB+ZWE+SDG+40675+40330+40334+40344+40606+40617+40603+40614+40618+40612+40616+40619+40611+40613+40630+40650+40651+40656+40642+40620+40640+UIS+40510+40525+40530+40505+40515+40520+40500+40535+40540+40550+WB+40044+40042+40030+40043+40041/all?startTime=2014&endTime=2020")),
    Table1 = Source{1}[Table],
    Table0 = Table1{0}[Table],
    #"Changed Type1" = Table.TransformColumnTypes(Table0,{{"KeyFamilyRef", type text}, {"Attribute:keyFamilyURI", type text}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type1",{{"KeyFamilyRef", type text}, {"Attribute:keyFamilyURI", type text}}),
    Series = #"Changed Type"{0}[Series]
in
    Series

Hi @Anonymous ,

It depends on your dataset, you need to expand the table to extract the corresponding data in power query.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors