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
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi madan,

 

As any changes in the data after processing the model would be immediately available for the users who are accessing the report is based on live connection from the Power BI service, and tiles on dashboard refresh updates every 15 minutes, I don't think it is a refresh issue in this case. 

 

So could you follow this official article to recheck the steps to implement row level security within your Analysis Services? :smileyhappy: 

 

Regards

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