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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
LD2022
Helper II
Helper II

Report Level Security / Object Level Security - Power BI Service

Hi All,

I have the following requirement:

  • 1 Workspace "Global"
  • 3 AD Groups Asia,Europe and Restricted
  • 2 Datasets :

     Dataset AE+ related reports to be accessed by Asia and Europe (not by Restricted)

    Dataset R + related reports to be accessed by Restricted only (not visible to Asia/Europe group.

 

How can I implement the security so the dataset R and related reports are only accessible/visible to Restricted Group only in the same workspace? Is it possible or it has to be a stored in a separate workspace ?

 

5 REPLIES 5
Greg_Deckler
Super User
Super User

@LD2022 Share each report with the respective AD Groups.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler 

Thanks for your reply. But when they access it using APPS or workspace, all the reports and dataset will be visible to them.

 Dataset AE+ related reports should be visibible to  Asia and Europe only

    Dataset R + related reports should be visibible to Restricted only 

@LD2022 No. Don't make them members of the workspace, just share the actual report. If you give them a role in the workspace, then they can see everything (although Viewer still enforces RLS). If you just share a single report in a workspace with a group of users, all they can see is that report. They cannot see the other reports. This assumes actual separate reports or are you using the word report when you should be using the word "page" of a report.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler 

They are individual report not page. 

When you say share the report with the groups, do I also need to restrict the report in Maneg Permissions?

Can you please share a screenshot of how to share with one AD groupand not the others ?

@LD2022 

Greg_Deckler_0-1663721750180.png

 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors