Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mkurup12
Helper I
Helper I

Power BI API

Hi!

 

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

 

Thank you!

 

 

3 REPLIES 3
v-jingzhang
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

 

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
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors