Forum Discussion

RobHess05's avatar
RobHess05
Helper I
4 years ago
Solved

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.

1 Reply