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 

1) For import mode, RLS won't work for the users(This account) who have edit access to this report, it has no nothing to do with access SSAS tabular, since the data has been imported into power bi dataset.

This only depends on if he/she could edit this report.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

 

2) For Live mode, all the RLS seting must been done in the SSAS

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

 

Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-lili6-msft,

    Thank you very much, and I am more clear now.

     

    For live connect, does MS has plan to provide dual mode? I mean support live and import in one report. Coz there are a lot of requiement that user need to pull some secured data from SSAS tabular and combined with some data on hand to do analysis.

    • 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