RLS with Power BI Embedded and SSAS Multidimensional Options RRS feed

  • Question

  • Hi,
    We're trying to do a POC with an web-app that will embed Power BI reports. When a user signs in, we want them to only be able to view the data that belongs to their organization. As a source we have a cube built with SQL Server Analysis Services Multidimensional. Embedding the reports are no problem. The problem is passing which user/organization is accessing the embedded report down to SSAS. I've found some posts about how to solve this with Tabular, but can't solve it for Multidimensional och everywhere I read I just see that this should be solved in the source, but not how.
    Can someone explain this to me?
    Friday, November 16, 2018 11:31 AM

All replies

  • Hi Saikumar_10,

    In this scenario, please have a check:

    Setup a role in the Multidimensional database in SSAS. Choose 'Read definition' and 'Read' access on the cube of interest. Under dimension data chose the CUBE DIMENSION which you want to filter on. Pick the attribute of interest and under 'Advanced' and 'Allowed member set': type the following expression:
    STRTOMEMBER('[Organization].[Organization Id].&[{'+CUSTOMDATA()+'}]')
    and of course replace Organization and Organization Id with your dimension attributes.

    See: RLS with Power BI Embedded and SSAS Multidimensional

    Dynamic Security in SSAS in Detail


    Pirlo Zhang 

    MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href=""></a>.

    Monday, November 19, 2018 1:29 AM