Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey,
I want to share reports to my colleagues in powerbi.com but they are not supposed to have access to the data set behind it. Is there a way to do that?
greets
Sarah
Solved! Go to Solution.
@SarahAlsterspre
Go to dataset settings in Power BI Service and choose options permissions.
Here, you need to add a user so that user has access to data in this dataset.
But make sure to deselect all options on this step.
"Allow recipients to modify this dataset" would enable user to edit/change dataset. So make sure this option is unchecked!
"Allow recipients to BUILD content with the data associated with this semantic model" would enable user to connect to this dataset via Power BI or via Excel and get all data. So make sure this option is unchecked!
Now, you can add that user as a viewer on this workspace.
User will see reports and dashboards, but not dataset (so user can't download dataset).
Alternative is to create App based on workspace.
By doing this, you grant users access to app, not to workspace. In app you can define what you want to show to end users (which report, dashboards).
When adding users to app, there is also advanced option where you need to uncheck "BUILD" permissions to dataset.
Cheers,
Nemanja Andic
Hi @SarahAlsterspre ,
One method: Share a report via link:
In a list of reports, or in an open report, select Share.
and don't choose build.
Two method:Manage permissions to a report.
To manage permission and manage links that give access to the report, select More options (...) in the upper right of the sharing dialog, and then select Manage permissions:
To grant users direct access to the report select the plus icon (+), enter their name or email address, do't choose it.
you also could refer this: Share Power BI reports and dashboards with coworkers and others - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@SarahAlsterspre
Go to dataset settings in Power BI Service and choose options permissions.
Here, you need to add a user so that user has access to data in this dataset.
But make sure to deselect all options on this step.
"Allow recipients to modify this dataset" would enable user to edit/change dataset. So make sure this option is unchecked!
"Allow recipients to BUILD content with the data associated with this semantic model" would enable user to connect to this dataset via Power BI or via Excel and get all data. So make sure this option is unchecked!
Now, you can add that user as a viewer on this workspace.
User will see reports and dashboards, but not dataset (so user can't download dataset).
Alternative is to create App based on workspace.
By doing this, you grant users access to app, not to workspace. In app you can define what you want to show to end users (which report, dashboards).
When adding users to app, there is also advanced option where you need to uncheck "BUILD" permissions to dataset.
Cheers,
Nemanja Andic
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.