Power BI API

[mkurup12]

Hi!

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

Thank you!

[v-jingzhang]

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.

[amitchandak]

@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

[mkurup12]

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