Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
@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