Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cannot retrieve data from SSAS with permission over specific Measures

Hi all,   I have a SQL Server Analysis Services Database running on-premises.   I created a Role, and specified only one measure that role can access:     If I use the Import mode when c...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

By my tests with connecting SSAS which configured with RLS by live connection and import mode, everything works as expected.

 

 

What kind of your credential when you use live connection?

 

Please create a measure with USERNAME() to get your current windows credential and check if this accout have permissions to access the data source in SSAS?

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-piga-msft thanks for your response,

     

    I use the Windows AD credentials of the user which I'm testing the permissions for:

     

     

    This is the role I created and the memberchip with that user, so it has permissions to access the data source in SSAS, so that's why I could test with import mode and it's working fine:

     

     

    Regards.