How to share dataset to others without giving them modify access

[michael95677]

It seems so simple and yet I can't seem to find an easy answer. I want to publish/share datasets I build that give the desktop users in our group the ability to connect to the dataset and build their own reports. We do not want them to modify the dataset but be able to write Dax against it or join it to other datasets etc. What is the best model for sharing datasets in this way? 

[Greg_Deckler]

@michael95677 You would need to enable datasets to be used cross workspaces in tenant settings. Then I believe you need to grant View access to the workspace although dataset sharing is coming:

Share access to a dataset - Power BI | Microsoft Docs

[michael95677]

Thank you. I think the question is if that allows the desktop user to write their own visualizations and joins to other datasets from their own desktops. Can they still use Dax to change datatypes for instance and be able to build their own reports without changing the dataset itself? 

[V-lianl-msft · Accepted solution]

Hi @michael95677 ,

Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report.

Please try downloading the pbix file of this report as workaround.

Download a report from the Power BI service to Power BI Desktop 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.