Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I have 2 dashboard (rapid market insight and rapid usage metrics )in my workspace
i have a sharepoint list
user | Rapid Market Insight | Rapid Usage Metrics |
Tom | NO | YES |
Prash | YES | NO |
Sam | YES | 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 )
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,
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.
@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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |