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.
