Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Regards.
Xiaoxin Sheng
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
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
1 |