The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
109 | |
68 | |
46 | |
42 |
User | Count |
---|---|
188 | |
86 | |
77 | |
74 | |
60 |