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...
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