joins

2 Topics

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.
DanyHoter
Aug 16, 2023 Place Azure Data Explorer Blog
3.2KViews
2likes
0Comments
KQL joins in Power BI and not only
Power BI classic star schemas do not translate well to ADX and direct query. The reason is the nature of joins between tables. This article will show different approaches to join when writing KQL and when PBI is generating the KQL.
DanyHoter
Aug 10, 2023 Place Azure Data Explorer Blog
3.5KViews
5likes
0Comments