Forum Discussion
whereismydata
Resolver IV
4 years agoexport 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:/...
- 4 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:
- 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
- Without an AS maybe create an PBI Premium account and just replicate the reports. Then export the RLS definition via the XMLA endpoint.
- 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.
d_gosbell
Super User
4 years ago
whereismydata wrote:
With my cubes I connect to the XMLA Endpoint and extract the definition. Is this also possible with PBIRS.
Unfortunately PBIRS does not have the equivalent of an XMLA endpoint and this is what you would need to extract the RLS filter expressions. I do not believe there is currently any way of automating the extraction of these definitions when using PBIRS.