Access to Report if dataset is in different workspace

[patelvatsal1621]

Is it possible provide report access on a seperate workspace without giving access to the underlying dataset to entire organization? I want to set up Power BI by keeping dataset in one workspace and ristrict the access to it, while the reports are shared with organization through different workspace.

[v-yetao1-msft · Accepted solution]

Hi @patelvatsal1621 

You can share the report to organization in the following ways .

(1) Share report directly with the link .

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards

(2)Create an app with the report and then publish the app to Organization .

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

(3)Share the workspace with the report contained.The following link is to introduce the different permissions of different roles in the workspace.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces 

However ,no matter which workspace your report comes from, as long as you want to share it with the organization, you must go to the workspace where the report is located, find the corresponding data set, and then add users to give access permissions .Or there is a notice that “Some of the content in this app comes from datasets in other workspaces. You may need to manage permissions manually to make sure everyone who should have access does have access” . As shown in the screenshot below.

Go to the workspace where the report is located, find the corresponding dataset, and then add users to give access permissions.

As long as they are given read permission, they can access this report(user with Pro or PPU license or the report in Premium capacity ) .

Best Regards

Community Support Team _ Ailsa Tao

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

[jvandyck]

this indeed works....however, I do not want consumers to be able to reshare the dataset....is there a way to accomplish this?

[CAPEConsultingS]

Hi @v-yetao1-msft 

after we give say read access to the PBI dataset, does the user need access to the workspace (where the report is) too or does read access to the PBI dataset give them ability to view reports irrespective of workspace access ? Also if there are 2 reports in 2 different workspaces and the PBI dataset is in a different workspace then is there a way to give user access to just 1 report and not to the other one (after we give them read access the PBI dataset) ?

[AbhiSSRS]

you should ahre these with apps and not workspaces. While creating apps please deselect the build permissions.

[patelvatsal1621]

@AbhiSSRS 

The problem with that is: I don't want people to access the underlying dataset with build or modifying permissions. The dataset needs to be only read permission. Is there are way we can allow users to connect to the App's underlying dataset using only read permission?