Matthew Kerr on 2021-04-13 13:20:53
I have created a composite model and published it to the service but having issues with other users seeing the data. Here is my current setup:
Workspace A:
PowerBI Dataset A
Workspace B:
Power BI Report A (composite model using the data below)
PowerBI Dataset A
Gateway access to 3 .csv files
Currently my users have view access on Workspace B. With this setup my users cannot see any data. I did some testing and the only way to get my users to be able to see the data in Power BI Report A was to either give them member access to Workspace A or to give them build access to PowerBI Dataset A.
Can we create the ability to keep their access as read only on the dataset.
Administrator on 4/11/2023 5:11:25 PM
Thanks - we are investigating to change this before GA of this feature.
Update 4/11/2023: this feature is now GA: https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-for-composite-models-on-power-bi-datasets-and-analysis-services-models/
- Comments (22)
- Merged Idea (1)
MOD Administrator on 2021-06-08 08:38:11
allow Viewer permission to access the composite model report
There is a limitation that "Users need ‘Build’ permissions on all datasets in the chain to access a report that leverages this feature." for DirectQuery for Power BI datasets and Azure Analysis Services (preview). Can allow "Viewer" permission of underlying dataset to access the composite model r...