Forum Discussion
Workflow best practices - dataflows, and datasets, and RLS, oh my!
Hello! Thanks for your thoughtful and detailed reply.
The linked article on golden datasets does seem to be the route I would like to adopt. Long-term I think having datasets that users can re-use where we already have the tables modeled correctly and some well-formulated measures premade is a great way to ensure data is reported correctly across departments.
One thing I am struggling with in adopting this model is permissions. Given the size of our university, we could have hundreds to thousands of employees trying to access reports/dashboards/apps based on these underlying datasets. What is the best practice is setting up these permissions? I had thought it would be to:
- Have a workspace housing the golden datasets. The only people with access to this workspace would be our IT data folks creating/edit those.
- Have workspaces for functional teams
- Reports would be created for those functional teams that use the underlying dataset (published across workspaces)
- Users are unable to access these reports because it says they don't have permissions on the underlying dataset
Is the only way to ensure access to reports is to allow access to all? Is there an easy way to do this without opening the workspace up to everyone?
Having a golden workspace and multiple workspaces for functional teams is the approach I use. You'll need to grant Build permission to users so they can access datasets in the golden workspace.
https://docs.microsoft.com/en-US/power-bi/connect-data/service-datasets-build-permissions