March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |