Power BI Premium Capacity Metric App - Query Duration

[Anonymous]

I've just had this app implemented and from my understanding of the metrics the query duration is indicative of the activity within the reports / visuals loaded, however, I'm seeing some conflicting information. 

I had identified two datasets with 0 query counts one in which I opened a dependent report and then the other I opened and clicked around on the visuals. The results were as expected once I had refreshed the apps dataset. But now I've indentified a dataset which appears to have a spike in queries around the same time as the actual refresh, however, when viewing the lineage of said data set I cannot see any views of these reports for the given time frame.

The two previous datasets have been refreshing daily with 0 queries so I'm confident the actual refresh shouldn't have an impact on this metric. What else could be causing the spike in queries when there's no views? 

[GilbertQ · Accepted solution]

Hi there

When you refresh a dataset, it will also refresh any underlying dashboards. And possibly if you have got the automatic page refresh this will also be refreshed.

When a refresh happens it will execute queries against the dataset.

[Anonymous]

Thanks for clearing this up - I had already considered it could of been a dashboard, but there wasn't any being fed by the dataset. I wasn't aware of the auto page reset - that will be the cause.