Forum Discussion
Power BI Service Concept
Hi IcingOnTheCake ,
If you provide the dataset and give the users Build Permission (and you aren't using RLS) then they will be able to make their own reports. As for their ability to add new datasources, you are correct that they can't do that yet. However, according to the Power BI Roadmap the ability for users to use composite dataset is coming soon (like next month soon). https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/direct-query-over-power-bi-azure-analysis-services
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Hi IcingOnTheCake,
I think you can try to build a template report with multiple data source connections.
It should do the process to get data from the specific data source with the connection string you provide, then you can do shaping and transform received data to the specific data structure to generate the data model tables and execute correspond calculate formulas and visuals.
For example:
The template has two parameters, one is the data source type, the other is the connection string. You need to add if statements to check the 'data source type' parameter and use corresponding data connectors with 'connection string' and extract specific fields from endpoint data tables and convert them with static table structure which matches with current report design.
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters
Deep Dive into Query Parameters and Power BI Templates
Notice: you need to limit the end-user data source types because these connections required you to manually defined them in the query steps.
Regards,
Xiaoxin Sheng