cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

JSON web services from Eurostat

Eurostat provides you with a method to connect to their public data via JSON-STAT

 

Here is the "How-To" from Eurostat

 

Now I've created my URL and what I did was basically the same way as always.

 

Get Data - From Web - Paste the URL and OK

 

The result I get is thiseurostatResult.PNG

 

 

 

 

 

All the values are stored in the value Records and the dimensions are stored in another Record. I need to create a table where the values are aligned with the dimensions (Time and Location)

 

This is the desired outputeurostatResultOutput.PNG

 

 

 

 

After going back and forth in trying to get a table from this URL, I simply can't. 

 

I suspect that I need to tweak something in Advanced Editor but my lack of M-formula knowledge is not helping.

 

Any ideas or help is greatly appreciated !

 

 

 

 

1 REPLY 1
Highlighted
Frequent Visitor

Re: JSON web services from Eurostat

I'd use the 'unicode' version of the query in this case (http://ec.europa.eu/eurostat/wdds/rest/data/v2.1/unicode...)

 

The JSON query basically needs serializing and cumbersome.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors