Power BI Desktop calls database when not refreshing?

[Anonymous]

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.

[lbendlin]

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

[Anonymous]

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]

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.

[Anonymous]

Sorry, what do you mean by the traces?

[lbendlin]

SQL Server Profiler or whatever tool you use to monitor incoming queries.