JSON API parsing

[Anonymous]

Hi All

I am trying to replicate the table on this website:

https://www.pxweb.bfs.admin.ch/pxweb/en/px-x-1602010000_101/px-x-1602010000_101/px-x-1602010000_101....

I can't manage to figure out the correct steps in Power Query. All I can extract are the different lists, separately.

I connect using this API link:

https://www.pxweb.bfs.admin.ch/api/v1/en/px-x-1602010000_101/px-x-1602010000_101.px

Looking forward to your suggestions!

Ben

[v-yulgu-msft]

Hi @Anonymous ,

You could have a look at this blog for detailed steps.

How to call REST APIs and parse JSON with Power BI

Best regards,

Yuliana Gu