Matthew Kerr on 13 Apr 2021 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 11 Apr 2023 17:11:25
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)
RE: Permissions for Composite models in the Service
One more issue that after switching to DirectQuery model, with some customized measures, I cannot publish to any workspace. Error: PowerBINotAuthorizedExeception"
RE: Permissions for Composite models in the Service
Same issue here! I think we should be able to publish a report like @Matthew Kerr's "Report A" to an app in Premium Capacity; and all our users should be able to view the report, *without* needing "build" permission on the dataset.
While this limitation is in place, the amazing new "composite model with Power BI Datasets" feature is not so amazing ... we can't use it for much of anything, so long as the reports cannot be shared with end users.
Also see this thread on the Community board:
https://community.powerbi.com/t5/Service/Composite-Model-Will-users-always-need-Build-Permissions-to/m-p/1775312