Forum Discussion
Relationship Error DIM to FACT
Good afternoon - I am building out a report that assists the user with Supplier Payment Installments (FACT) data that uses some relevant info from Supplier (DIM) and Supplier Invoice (DIM) - These joins work in the relevant Snowflake data table using the same logic (joining on relevant keys) but in my Power BI semantic model, they don't talk to eachother.
Supplier Invoice Lines (FACT) is set up the same way, and i've checked the data types on the joining keys, all match. Below is some more information, please let me know if I can provide more info.
| Table 1 | Relationship Type | Relationship On: | Table 2 | Status | Notes |
| Supplier (DIM) | 1 to * | Supplier Key | Supplier Invoice Lines (FACT | Works as expected | |
| Supplier (DIM) | 1 to * | Supplier Key | Supplier Payment Installments (FACT) | Does not work | Blank table |
| Supplier Invoice (DIM) | 1 to * | Supplier Invoice Key | Supplier Payment Installments (FACT) | Does not work | Shows suppliers and payment installment amounts but the amounts don't match what is in the table in our warehouse |
| Supplier Invoice (DIM) | 1 to * | Supplier Invoice Key | Supplier Invoice Lines (FACT) | Works as expected | When I add Supplier Payment installments to this it doesn't BREAK but data doesn't match to the warehouse table |
1 Reply
Hi strongman_pbix ,
It seems like the data in the visual didn't display the expected result base on the current relationships between the fact tables and dimension tables. Could you please provide the following info for the further troubleshooting?
- Provide some sample data(exclude the sensitive data) in these tables, you can refer the following link to share the required info:
- The visual fields settings
- If the visual involves any measure, please provide the related formula.
Best Regards
