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.
[New post] Microsoft Fabric real-time analytics exploration: Eventstream Custom apps integration
Learn how customs apps can be integrated in Microsoft Fabric using EventHub-compatible public endpoints living in Fabric Eventstream, both for ingress and egress. These are part eight and nine in a series of posts about Fabric for IoT Engineers. Check out Ingress https://sandervandevelde.wordpress.com/2023/12/02/microsoft-fabric-real-time-analytics-exploration-eventstream-source-for-custom-app-ingress/%20 and Egress https://sandervandevelde.wordpress.com/2023/12/02/microsoft-fabric-real-time-analytics-exploration-eventstream-destination-for-custom-app-egress/#mvpbuzzRelationships 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.
