Press "Enter" to skip to content

273 Queries to Refresh a Single Chart

Dany Hoter performs some troubleshooting:

A customer approached me and complained that a page in a PBI report was taking a very long time to refresh. (> 100 seconds)

An investigation showed that one chart was sending 273 queries to the ADX cluster.

Was it a coincidence that the chart showed a distinct count of customers in each one of 273 points of sale?

Spoiler: no, no it wasn’t.