Forum Discussion
What's the best way to capture data from multiple identical API endpoints into a single dataset?
I created my own custom connector based off of the Microsoft TripPin tutorial: https://docs.microsoft.com/en-us/power-query/samples/trippin/1-odata/readme
In their example, they are reading data from a single endpoint: https://services.odata.org/v4/TripPinService/Me
In my example, I have an endpoint that is structured identically to theirs, but has separate credentials and unique data: https://mycustomservice.odata.org/myTrippinService/
If I get the data in the Power BI app from both endpoints, then I'm creating a duplicate set of tables for every new endpoint. Is it possible to create a view that dynamically joins all of these tables into a single view? (Simalar to a SQL join when creating a view)
Is it better to adjust the custom connector to accept multiple endpoints & credentials, then programmatically stitch it together with code?
I'm not sure if either approach is possible, so I'm just looking for best practices from the community. Thanks for reading.
- Anonymous4 years ago
HI RobHess05,
I'd like to suggest you parameterize your connection string to create a template report, then your users can use it or generate their own report based on connection strings.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Regards.
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
HI RobHess05,
I'd like to suggest you parameterize your connection string to create a template report, then your users can use it or generate their own report based on connection strings.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Regards.
Xiaoxin Sheng