Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

SSAS Multidimensional Security Role Not Working on PowerBI server (on-perm) Reports

We are seeking your assistance in populating filtered data from SSAS Multidimensional cube on the Reports, which are deployed on PowerBI Report Server (on-prem).

 

Currently, when Power BI Connect with SSAS Via live connect, all the users who have access to the report will the all the data.

 

To overcome this problem, we implemented the SSAS Multidimensional Security Roles. SSAS Multidimensional Security Role is working fine with Excel and MS SQL Cube Browser.

 

Our goal is simple, we want to connect PowerBI Report Server (on-prem) Reports with SSAS Multidimensional Security Role to populate filtered data from the cube on the report.

 

Or anyone has any other solution for populating filtered data from SSAS Multidimensional cube on the PowerBI Report Server (on-prem) Reports

 

For more details, please refer below. 

 

https://stackoverflow.com/questions/71377472/ssas-multidimensional-security-role-not-working-on-powerbi-server-on-prem-repo

 

 

Need Help

7 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    4 years ago

    You need to change the Authentication type to below for SSAS connection

    you need to connect with Admin User, then need to impersonate it accordingly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you very much Farhan, I am already Connecting with a User who has admin rights but when I checked to impersonate option and save, an error is coming.