Why are 273 queries needed to refresh one chart in Power BI ?
A real case from the field in which a huge number of queries were send to an ADX database for refreshing a single visual. The reason was a wrong choice of storage modes for dimension tables. Alternative solutions are suggested at the bottom of the article.Relationships between ADX tables on two databases or two clusters
When using relationships between two ADX tables, we always prefer a join to be used between the two tables What if the two tables are not in the same database? This article will explain how to ensure proper joins are generated for these case.
