Forum Discussion

madan's avatar
madan
Frequent Visitor
9 years ago

Power BI Dashboard refresh issue.

Hi,   I have build a power BI dashboards on top of on-premise ssas datasource and the RLS is implemented at SSAS and i shared this dashboards with other members of my organization. When a member lo...
General Comment
madan's avatar
madan
Frequent Visitor
9 years ago

Hi v-ljerr-msft

 

Thanks for you time. I saw the post that you tagged in your reply, it refers DAX function USERNAME() while definig RLS in SSAS. I have MDX code that defines RLS and is working fine when i refer my SSAS from perfomance point and other applications. my question is, is it a must to refer USERNAME() while defining RLS in SSAS for PowerBI dashboard to filter the data based on logged in user role?

madan's avatar
madan
Frequent Visitor
9 years ago

i am connecting to SSAS MD with live connection, power bi dashboard is displaying the data but is not applying the RLS. I have changed my SSAS cube RLS to refer USERNAME() but still the same issue.

I see in some posts that Power BI should work fine with the SSAS MD security model defined at dimension level and i have setup my security in my cube at dimension level only.

Anyone had similar issue? Does Power BI filters data only on SSAS Tabular model?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi madan,

    Does Power BI filters data only on SSAS Tabular model?

    According to this official documentation, dimension and cell level security should be supported by way of Roles for SSAS Multidimensional Models in Power BI. 

     

    Multidimensional models support dimension and cell level security by way of Roles. 
    When you connect to a cube with Power BI, you are authenticated and evaluated for appropriate permissions. 
    When a user has dimension security applied, the respective dimension members are not seen by the user in Power BI. 
    However, when a user has a cell security permission defined, where certain cells are restricted, then that user cannot connect to the cube using Power BI.

     

    In addition, I found a similar thread here which mentions Map user names on Power BI Service could be related. Could you go and check if it helps.:smileyhappy:

     

    Regards