Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Desktop calls database when not refreshing?

Hi everyone,

 

I am currently working with a large dataset in power bi desktop. On desktop we only load one day of data due to volume, we then work with incremental refresh, tabular editor, alm toolkit, etc to make changes into the dataset.

 

Today I was given a little warning by the data team at my work for running multiple instances of this large table - one very 2 or 3 minutes acording to the screenshot they sent me - but the thing is I haven't modified this fact table, or even refreshed the data at all. I'm really just modifying a couple of dimension tables and creating new measures.

 

So, is desktop making calls to the database even when not refreshing? Is there an option to deactivate this? 

 

Thanks in advance.

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Validate if one of your connections is in Direct Query Mode.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,
      It's a mixed model: I have most connections in import mode, and then a connection to a dataset published in my workspace. 
      The query that was being launched constantly was for one of the imported tables.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Do you have the query traces?  Most likely your import table is joined to the dataset.

         

        In the Power BI Desktop settings you can limit the background activities, but you cannot fully control the meta data chatter.