Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have :
2 master table dim: Master_Area and Master_Date
3 fact table : FACT_TABLE_A, FACT_TABLE_B, FACT_TABLE_C
When I connect Master_Area 1: many to FACT_TABLE_A, FACT_TABLE_B, FACT_TABLE_C, everything is running well
but when I connect Master_Date1: many to only FACT_TABLE_A can connect (line in full line not in dotted line) for FACT_TABLE_B, FACT_TABLE_C it comes with the error message :
Solved! Go to Solution.
Hi @Delion ,
I think the main reason is that the wrong activity relationship is set up. Generally speaking, there can only be one active relationship between two tables. If there is more than one relationship, it needs to be set as an inactive relationship. In addition, specific screening directions may also cause errors. Therefore, you can refer to the specific official documents to view the relationship model between the constructed dimension table and the fact table.
reference document link: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Delion ,
I think the main reason is that the wrong activity relationship is set up. Generally speaking, there can only be one active relationship between two tables. If there is more than one relationship, it needs to be set as an inactive relationship. In addition, specific screening directions may also cause errors. Therefore, you can refer to the specific official documents to view the relationship model between the constructed dimension table and the fact table.
reference document link: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you don't want to have problems with your model and DAX calculations, I'd stick to star schemas with the default simple one-way filtering. This is how real professionals do it. If you want to know more, please read this: Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
It's not possible to give you a full answer because the diagram doesn't show the direction of the relationships (i.e. how they filter) but basically powerbi prevents alternative paths between tables. There must be (at most) only one path between any two tables.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
164 | |
132 | |
131 | |
95 | |
86 |