cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Prasala583
Frequent Visitor

Row Levle Scurity

Hello All,

I have 2 dashboard (rapid market insight and rapid usage metrics )in my workspace

Rapid_workspace.PNG

i have a sharepoint list

userRapid Market InsightRapid Usage Metrics
TomNO

YES

PrashYES

NO

SamYES

YES

 

My requirement is based on the SharePoint list I have to grant the access at the Row Level Security

For example

For the Rapid Market Insight dashboard only the users Prash and Sam should have the access

This SharePoint list is dynamic there will be new users added and removed

How can I limit the access at the row level based on the SharePoint list ( in the SharePoint if the rapid market Insight is YES then the users should have the access to view the data, If it is NO then the usres shouldn’t have the access )  

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @Prasala583 

you can created roles, rules and set RLS for a dataset in the Power BI service. In your table, there are 2 different reports Rapid Market Insight & Rapid Usage Metrics, if they are created based on the same dataset, you can set RLS for this dataset.

For more details about how to setting RLS, please review this article,

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#define-roles-and-rules-in-power-bi...

vxiaotang_0-1632214591969.png

 

 

Best Regards,

Community Support Team _Tang

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

AllisonKennedy
Super User
Super User

@Prasala583 Are you looking for ROW level security or Report permissions? You'll need to pull the SharePoint list into the datasets for both reports if you want to use it to dynamically edit the access to the data within the reports, but you haven't detailed which rows they should have access to so not sure which DAX filter function to have you use. We need to know what the data model (tables, relationships) looks like and what data those users should be able to access. 


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors