Forum Discussion

tagoreb's avatar
tagoreb
Advocate IV
9 years ago

Automatic Data Refresh behavior on SSAS Tabular model

Hello   We have PBIX connected to SSAS Tabular model as Live Connection.  We have been observing that all dashboard queries are running in the background for each user who have access to the dashbo...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tagoreb，

Have you applied Row Level Security(RLS) in your dataset? Based on my reserach, using RLS on a dashboard tile usually means the refresh of a tile requires one query per user,

Thanks,
Lydia Zhang

tagoreb's avatar
tagoreb
Advocate IV
9 years ago

Hi Lydia

 

Yes, we have implemented RLS.  I understand that dashboard tile refreshes for each user but it should happen when the user logged in.  However, it is happening irrespective of whether user logged in or not while running the automatic data refresh.

 

This could be expected behaviour and will see whether the microsoft address this in near future.

 

Thanks

Ravi

  • RahilBukhari's avatar
    RahilBukhari
    Advocate I
    9 years ago

    Hi

    Did removing the roles solve the issue? We're experiencing something similar, we have a number of dashboards and reports published to workspaces in PowerBI querying an on premise Tabular 2016 model and we can see a LOT of activity from PowerBI and I don't believe that majority of this is from end users. It looks like it's being triggered by Power BI.

     

    We also had role level security but this has now been removed and i'm in the process of monitoring the server. Just wanted to see if anything else was discovered on this thread?

     

    Thanks

    Rahil