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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
TutanRamon
Frequent Visitor

[Beginner] Consume multiple endpoints from same API - how to setup?

Dear all, I am pretty new to Power BI. 

 

I have access to an API which can provide me all the data I need. So, for the sake of simplicity, lets say the base URL of the API is https://www.webshop-api.nu/v1/

 

To connect to this API, I need to use basic Auth and a custom header named apiToken. 

 

I need to retrieve the following data

 

What's the best way to approach this? Can I define a 'base connection' so I only have to enter the credentials/headers once? Or do I need to define each endpoint as a seperate data source? When, for instance, the credentials change, I don't want to edit all data sources. So, what's the best way to do this?

 

Thanks!

1 REPLY 1
new2pbix
Frequent Visitor

@TutanRamon  Any update on this?  I have the same problem. I have a url similar to this: .../v1/students/{id}/detail where I may have 1000 different id's and i want to bring all the student id details into one table. I dont want to create a table for each student detail (id would be 1,2,3,4,5,6,...1000). so /v1/students/1/detail, .../v1/students/2/detail, ...v1/students/150/detail.. seems like this should not be a difficult process. Any help you can provide would be very helpful

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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