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

[Anonymous]

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-powe...

[FarhanAhmed]

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]

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. 

[FarhanAhmed]

Can you please share the error ?

[Anonymous]

[FarhanAhmed]

make sure that you are entering "Domain\UserName" instead of "username"

[Anonymous]

Same result with Domain\username

[FarhanAhmed]

Are you able to log in with this user to SSAS using Management Studio?

Also check if any Group Policy is avoiding you to store the Password for the user.

Ref: Error: A specified logon session does not exist. It may already have been terminated. (Exception fro...