What's the best way to capture data from multiple identical API endpoints into a single dataset?

[RobHess05]

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.

[v-shex-msft · Accepted solution]

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.

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power B...

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

Regards.

Xiaoxin Sheng