Connect to API

[Lietotajs]

Hello!

I would appreciate it if someone could explain how I can connect Power BI and retrieve data using an API. I am trying to access statistical information from the Official Statistics Portal in Latvia. Example data:

https://data.stat.gov.lv/pxweb/en/OSP_PUB/START__VEK__PC__PCI/PCI050c/table/tableViewLayout1/

I don’t understand how to include the JSON in a query. I am currently stuck.

[v-xuxinyi-msft]

Hi @Lietotajs 

Perhaps the following document can help you.

https://learn.microsoft.com/en-us/power-query/connectors/json#load-from-the-web 

How to get data from REST API (JSON) in Power BI? - Microsoft Fabric Community

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.