Skip to main content

Power BI

Needs Votes

Copy RLS roles on reports and datasets

Vote (24) Share
Marcelo Mello's profile image

Marcelo Mello on 24 Apr 2017 19:21:36

I am working with reports that use different datasets (Excel worksheets and database tables Oracle and Mysql) but the RLS is common for all them. I suggest the implementation of a routine on PowerBI Desktop and on the on-line version to copy the RLS roles between reports and datasets.

Comments (1)
Marcelo Mello's profile image Profile Picture

maps apps on 06 Jul 2020 00:18:19

RE: Copy RLS roles on reports and datasets

I know that a blocker would be that two datasets might not have the same table or same field available but in my case, simply being able to copy the list of RLS without any link to a specific table would save me to rewrite 180 RLS name everytime. I would simply have to assign them with table and filter.