The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Are there any easy ways to apply one row level security role to multiple datasets? Or should I always have to create the role for every report in desktop and add the same list of users to the role in Power BI Service ?
Hi @Raaassotto ,
If the data sources of your several reports are the same, you can try to attribute multiple reports to one data set. Specific operations can refer to:
Create reports based on datasets from different workspaces
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Data sources often are not the same. For example the the list of users for financial data is the same, but there are many sources for the data that qualify as financial
@Raaassotto , I think RLS is file specific, so you have to be repeated for each file. Check if import a power bi dataset can help
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
181 | |
82 | |
63 | |
47 | |
43 |