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.