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,

I am trying to test the scenario as yours, however, I get a different result on my side, please check the details in the following screenshot.  I added three users in Power BI group. Could you please share me the result of your SQL trace?






Thanks,
Lydia Zhang

tagoreb's avatar
tagoreb
Advocate IV
9 years ago

Hi Lydia

 

Please check the Query Begin Text Data and you will get the <effective user name> tag and you can see those queries triggered for those 3 users you added.  

 

Our expectation is that those queries should get triggered/seen only when the user login to PBI service and when try to access the dashboard.  However, with out user's interaction, while automatic data refresh is processing, we are seeing the query entries in Trace.

 

We have 100+ users added as members and hence you can see more Query Begin and End entries in the Trace.  Please find the below screen shot as requested.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi tagoreb,

    I have checked <effective user name> tag in each Query Begin Text Data. However, I am not able to reproduce your issue. In my SQL trace, those DAX queries get triggered only when the group members login to PBI service and access the dashboard. Also during the automatic data refresh process, the <effective user name>  is always me if the three group members don't access the shared dashabord and report.

    How do you grant the group members access to gateway in Power BI Service? Do you embed the report in other application?

    Thanks,
    Lydia Zhang

    • tagoreb's avatar
      tagoreb
      Advocate IV
      9 years ago
      Hi Lydia We used Workspace name in data source in gateway so that all members part of workspace will get access always. We did not embed the report in any other application. Thanks Ravi
      • 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