Forum Discussion

whereismydata's avatar
whereismydata
Resolver IV
3 years ago
Solved

export RLS definition

Hi,   can somebody help me please find a solution to export RLS filter definitions? We use PBIRS Jan2022   I need this for an internal security monitoring.   What I tried so far: API (https:/...
RLS
  • whereismydata's avatar
    whereismydata
    3 years ago

    Hi d_gosbell, thank you for helping me understand the issue and possible solutions. I hope I got all the facts straight!

     

    In short one has two (or three) possible solutions:

    1. If there is an Analysis Service Server (AS) somewhere around, move all data modelling to the AS. This way RLS definiton can be exportet via the XMLA endpoint
    2. Without an AS maybe create an PBI Premium account and just replicate the reports. Then export the RLS definition via the XMLA endpoint.
    3. Not really an option for users in this subforum: Move all projects to PowerBi Service

     

    Although I have an premium workspace to play around with, I think I'll redesign all my reports and will use AS as single data source. This way I can export RLS definition via the XMLA endpoint. 

     

     

whereismydata's avatar
whereismydata
Resolver IV
3 years ago

Hi d_gosbell ,

 

ok, thank you for the detailed explanation. Although this is the Report Server subforum, do you know if there is a solution within power bi service?

  • d_gosbell's avatar
    d_gosbell
    Super User
    3 years ago
    whereismydata wrote:

    Hi d_gosbell ,

     

    ok, thank you for the detailed explanation. Although this is the Report Server subforum, do you know if there is a solution within power bi service?

    If you have premium you could query the XMLA endpoint to get this information. I don't think there is an equivalent for pro workspaces.