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.How to Create a Table in Microsoft Dataverse
Microsoft Dataverse, formerly known as Common Data Service (CDS), is a cloud-based data storage and management platform provided by Microsoft as part of its Power Platform. It allows users to securely store and manage data from various sources, such as Dynamics 365, Office 365, Power Apps, and Power Automate, and use that data to build custom business applications.
Wrong Filter Flow Direction when using Excel Power Pivot
Hello everyone! I am having a problem which is doing my head in. So in the file attached, you can see that I have a table for Package, a table for Arenas (Products), and a table of which arenas belong to which Packages. An Arena can belong to 1 or many Packages and a Package can include 1 or many Arenas, therefore I created a table between them where you simply add this information. Now, I want to see which arenas belong to which Packages but the filter direction goes in the "wrong way". I want to be able to filter the Package table and see which arenas that belong to that package but as you can see, I get that all arenas are included in all packages (because of the filter direction). If this was Power BI, I would change the direction of the relationship to "both" but this does not seem to be a function in Excel Power Pivot. I need help 🙂 Kind Regards, Kind Regards, Robin
