Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi experts,
Need your help here.
The requirement is the end user should have access to modify the published reports, can create their own reports and visuals but should not be able to edit the dataset. PBI dataset should be red only.
We tried adding End users as "Contributer", this way they can edit the report but they can also edit the datasets.
Is there any way we ca stop them modifying the reports but not the PBI datasets?
Thanks.
For your scenario, follow the solution that @AbhiSSRS posted.
Doing so, the end user can do the below
1. Save-as an existing PBI report that is decoupled from the dataset, then the user can edit this saved-as report
2. the user can create new reports on top of this dataset, the dataset is accesible only in read only mode.
3. the user can access this datamodel in Excel
And, the end user cannot do the below
1. Cannot download the shared PBI report
2. Cannot download the saved-as report
3. cannot download the data model
I tested all the above as of 13Dec2022.
Contributor adds write permission to the dataset. This allows users to make changes to dataset.
Permissions upto Build permission will allow user to create reports as well.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions
Hello @Anonymous,
I was told to give the same requirement as the one you mentionned.
An end user needs to modify the existing report on PowerBI service but SHOULDN'T be able to modify the dataset. Did it work for you ? Because "Contributor" allows the user to access and modify the dataset.
Regards,
HI @Anonymous ,
Hi @Anonymous ,
I refer to the description of the permissions section in the official article.Contributer could not manage dataset ,and if you want to mange dataset ,you need to be a member.And I found if you are "Contributer" ,you could
edit report and could manage dataset ,this is what you are looking for .
To learn more details ,you could read the following article:
Sharing a dataset but NOT allowing anyone to edit it?
Wish it is helpful for you!
Best Regards
Lucien
The best development approach is to have datasets seperated from pbix reports. In fact you may delete the pbix which has the dataset originally from the workspace.
Users can then develop their own reports connecting live to Power BI datasets without having any access to edit it.
In the service , you may use below options while sharing so that users are able to create reports with your datasets.
Exactly what I was looking for. thanks a ton.
Hi @AbhiSSRS
Many thanks for your reply.
We are using the same approach. Our dataset and report are two different PBI files.
In that case do we need to add users at the Dataset level --> Manage Permissions. if yes what type of access so that they can't edit the dataset.
Thanks
The dataset that for which you have the associated report deleted can never be downloaded to edit. So that takes care of it for most developers. Its only allows for live connection if created from desktop or creation in service and that file can't be downloaded with dataset ever.
Hi @AbhiSSRS,
in my case the end user needs to modify the form of one visual each month on the report but they were asking me not to give him access to the dataset associated, i don't know if my explanation is clear
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.