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,

Do you share the dashboard to user via the following option or add your users in Power BI Group?


From my point of view, this is an expected behavior that all users you share dashboard with are running queries , because Power BI needs to refresh data for each user when there are changes in the dataset. Please help to describe more details about how you share the dashboard and I will test your scenario in my computer.

Besides, I am afraid that there are no official documentations about Automatic data refresh behavior on live connection.


Thanks,
Lydia Zhang

  • tagoreb's avatar
    tagoreb
    Advocate IV
    9 years ago

    Hi Lydia

     

    Thank you for your time.

    We add users as members to the workspace to give access to the dashboard and reports.

     

     

     

    Thanks and Regards,

    Ravi

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