Forum Discussion
export RLS definition
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.
Hi d_gosbell ,
thank you for taking time looking into my issue.
Regarding your answer. I came across some articles that state that a PBIRS Dashboard basically has an underlying SSAS instance running. But none of these articles explain how to connect to those instances. Do you have, by any change, some insight into this?
Thanks again!
whereismydata wrote:
Regarding your answer. I came across some articles that state that a PBIRS Dashboard basically has an underlying SSAS instance running.
This is correct
whereismydata wrote:
But none of these articles explain how to connect to those instances. Do you have, by any change, some insight into this?
This is because there is no way to do this.
The internal instance is fully managed by PBIRS. Data models are loaded in and out of memory on demand and it sometimes even load multiple versions of the same data model is loaded into memory (like when doing a deployment or during a scheduled refresh). So you would not have access to all the data models and the ones that do happen to be accessible only have guids for names and could be unloaded from memory at any time.
What you would need is an officially supported XMLA endpoint, but this does not exist for PBIRS.
