Forum Discussion

sunilravinder's avatar
sunilravinder
Frequent Visitor
8 years ago

Power BI Report Server interaction with SSAS Multidimensional Cube with row-level security

Hi,   We have SSAS multidimensional cube configured with dimension security. We have a Power BI Report Server configured with the live data source connecting to the cube. We are using Windows authe...
Report Server
Jon-Heide's avatar
Jon-Heide
Microsoft Employee
8 years ago

Hi Sunil - what you describe seems correct and that it should correctly impersonate the user. One thing to try, ensure you are using the latest build of the June PBI Report Server release. There was a bug, fixed in the update, where using impersonation did not function correctly. Also, you can check your config, by using a PBI report that contains a measure = username. When you view report, you can see in the report what user it is running under. Also make sure hte SSAS server is joined to same domain, so it can resolve the user identity.  

  • sunilravinder's avatar
    sunilravinder
    Frequent Visitor
    8 years ago

    Hi,

     

    We realized we are doing data-level security which is not supported by Power BI. Once we removed it and made it row-level security it worked.


    Thanks,

    Sunil