Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi!
I am new to APIs. Is there a way to import all the API data (from Swagger UI) into PowerBI?
Thank you!
Hi @mkurup12
If your APIs' urls have an identical format, you can replace the identical part (usually the variables) with a parameter, then create a custom function to invoke it. You just need to change the parameter value. Or you can use a table to contain all parameter values and add a new column by invoking this function to bring all data into the table.
There are some great blogs about this.
Getting Started with API's in Power Query • My Online Training Hub
Power Query Custom Functions • My Online Training Hub
Video:
Accessing API and web service data using Power Query - by Chris Webb - YouTube
I learnt a lot from above resources. Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@mkurup12 , refer if the solution in the past can help
https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006
Do I have to do this individually for all the endpoints that I want to import?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
75 | |
74 | |
55 | |
45 |
User | Count |
---|---|
117 | |
106 | |
77 | |
66 | |
65 |