Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Power BI API



I am new to APIs. Is there a way to import all the API data (from Swagger UI) into PowerBI?


Thank you!



Community Support
Community Support

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



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.

Do I have to do this individually for all the endpoints that I want to import?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors