Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RLS on SSAS (Import Mode)

I am very new on SSAS, based on the document RLS setting on tabular is working on import mode for Power BI. I have some questions on this, please help to address. Thanks in advance. 1) For import mo...
Data Protection
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    It could not achieve that support live and import in one report.

    Since you are live connect to a whole data model of SSAS, you could not create or adjust the model in power bi any more.

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi Anonymous 

It could not achieve that support live and import in one report.

Since you are live connect to a whole data model of SSAS, you could not create or adjust the model in power bi any more.

 

Regards,

Lin

alexrobe_aht's avatar
alexrobe_aht
Frequent Visitor
6 years ago

We have a similar issue, where mainly for performance (and report creation speed) issues as well as smaller ETL jobs, we seem to be forced to connect via direct query mode to our SSAS-model.

Is there any way to take over the SSAS rights scheme and import it into PowerBI and somehow use it for RLS on the imported model?

 

use case:

We have a big global model for multiple plants. Most users shall be restricted to only their plant, some users shall see most/all plants.

Question is: How can the usergroups be maintained (or even created?) automatically, if their access rights settings change in the SSAS model?

Any other approach also welcome to solve this challenge.

 

Thanks a lot,

Alex