Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am creating a 'Template App' that connects to an Azure MS SQL database.
I want the end users to be able to change the data source on the Template App to their own data source.
The Template App is in pre-production so it can be shared with other organisations.
I have enabled the required options on 'control' when creating the App to allow the users to add their own data sources,
As per Microsoft's guidance...
'If you want to limit access to your queries and measures while still allowing your users to add their own data sources, consider checking only the Export or externally connect to data options. This enables users to add their own data sources without being able to edit your dataset'
located here: https://docs.microsoft.com/en-us/power-bi/connect-data/service-template-apps-create
The issue is the end user (whether from my own organisation or from a outside organisation) find the App Data Source always hard coded.
(server and database cannot be edited - blanked out)
Anyone?
Solved! Go to Solution.
Using Parameters in Power Query sorted this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.