Forum Discussion
Solved
How to copy/paste RLS from one pbix. to another?
Hello, How can I copy and paste all the Rules that I have in one .pbix file to another? Every release that I made I need to recreate my RLS into the new .pbix file, this is insane. Best Regards...
HI brunozanoelo ,
In fact, power bi does not limit the role amount of RLS. So for your requirements, you can create different roles and assign roles to your users.
For instance, you have 10 users and they need to be filtered by their usernames, you need to hard code 10 roles for each user. If you create a dynamic username role, you can use one role on all users. (RLS with username can be used to reduce role amount of similar user roles)Regards,
Xiaoxin Sheng
With the PBIP format, it is now possible to copy and paste from one file to another.
- Save your Power BI file as .pbip.
- Navigate to the folder path:
YourReport.SemanticModel /definition /roles. - Copy the contents from there and paste them into the same location in your new Power BI report.