Forum Discussion
Power BI Premium Capacity Metric App - Query Duration
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?
- 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.
2 Replies
- 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.