Report access to edit and download

[Anonymous]

Hi ,

We have created something similar to adhoc report. It will allow user to download the adhoc report and built their own visuals.

My query is since there will be multiple users using this adhoc report, i want to restrict users to delete another users report, and at the same time they should have access to download the adhoc report as well. Is there any way to achieve this?

Regards,

Priyanga

[vanessafvg]

So what you are saying is you have a built a dataset and you want users to build their reports on this dataset?

If are they downloading it  into power bi desktop, doing some analysis and then reuploading and overriting the current adhoc reports?  How are they able to delete another users report?

It might be better To create one dataset and all reports thast are built build off the central power bi dataset.  People can then create their own reports but just l link to the dataset in the work space via a power bi dataset connection.

[Anonymous]

Hi @vanessafvg ,

So what you are saying is you have a built a dataset and you want users to build their reports on this dataset? - Yes

If are they downloading it  into power bi desktop, doing some analysis and then reuploading and overriting the current adhoc reports?  How are they able to delete another users report? -  no not edit the centralised report. Based on centralised report they will create their own reports and upload again. So how can we restrict users to delete or update another users report

Thanks,

Priyanga

[vanessafvg · Accepted solution]

if they all have access to create reports in a workspace there is no way to limit with permissions what people do unless i misunderstand what you are asking.  The best way to manage people to not overwrite other reports is via training.

Secondly, dont let them download reports from the workspace to change it.  I think 2 other options might be better depending on what your requirements are. 

Make them create their own reports either by sharing a templated file from sharepoint or one drive

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-templates

or by making them only connect to the dataset via their power bi desktop.  Create the dataset in the workspace, this way they dont need to download the file from the workspace.    They can then access this in their power bi desktop.

do this by creating a dataset of your model in the workspace.  They then via power bi desktop they connect to that dataset without having to download any file.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets