Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
patelvatsal1621
Frequent Visitor

Access to Report if dataset is in different workspace

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.

 

 

1 ACCEPTED SOLUTION
v-yetao1-msft
Community Support
Community Support

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 

Ailsamsft_0-1630552810117.png

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.

Ailsamsft_1-1630552810120.png

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

Ailsamsft_2-1630552810124.png

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.

View solution in original post

5 REPLIES 5
v-yetao1-msft
Community Support
Community Support

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 

Ailsamsft_0-1630552810117.png

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.

Ailsamsft_1-1630552810120.png

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

Ailsamsft_2-1630552810124.png

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.

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

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
Solution Sage
Solution Sage

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

 

AbhiSSRS_0-1630407377852.png

 

@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?

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors