Forum Discussion
Permission Required - Shared Datasets
- 4 years ago
You can leverage the Build Permission to grant the necessary access, which grants users access to the dataset but not to the report contents. This is much more manageable leveraging AD Security Groups.
Setup:
1. Workspace A contains Dataset 1. Access to Workspace A is managed via AD Security Group called AD_WSA.
2. User builds Report X from Dataset 1 and publishes to Workspace B. Access to Workspace B is managed via AD Security Group called AD_WSB
In the above configuration, grant build permission to AD_WSB to Dataset 1 located within Workspace A. This way users of Report X can see the data in Dataset 1 but not have direct access to Workspace A.
This is odd and not expected in my experience.
From what you described, it does not appear that your user has build permissions on the dataset. In my experience, if a user cannot see a datset from the PBI Dataset within desktop it indicates directly that they do not have build permissions.
That my point, I am sure this user has a build permission on the dataset but she cannot see them from PowerBi Desktop.
I "solved" my issue temporary because I have add the Contributor permission on the workspace but that is clearly not what we want.
I guess I have to raise a ticket to Microsoft to investigate.
NB: we did a test on a PoC Tenant and this build permission was working as expected. I don"t see the difference with our config.