Microsoft Power BI - Limited Relationships in Mixed Query Modes
@poweraegg explores limited relationships inside Power BI. Looking at mixing import mode with direct query, we can have some dangerous analytical scenarios where summing values from the fact table may return unexpected results. We also check out what the data model using direct lake when connecting to a Microsoft Fabric Lakehouse Semantic Model looks like, and how it can be misleading as it looks like a limited relationship.