Forum Discussion
Inconsistency in data
- Anonymous1 year ago
Hi Miedziu,
Thank you for reaching out to Microsoft Fabric Community Forum.
Possible Causes of Missing Data Based on Your Scenario
- One possible issue is missing or mismatched relationships. Ensure that iEBS 5 and iEBS 6 exist in both related tables and match correctly on the key columns.
- Another reason could be Row-Level Security (RLS). If applied, it might filter out iEBS 5/6. Test by disabling RLS via "View As" in the Modeling tab.
- Lastly, check for filters on visuals, pages, or reports. Filters or slicers might be unintentionally excluding the new values.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu - 1 year ago
Possibel Reason:
Many to many cardinality relationship between 2 tables
You have a many to many relationship between 2 tables , The IEBS4 has values in one table and not in another
Solution:
Create a bridge table
The bridge table will act like a bridge for the 2 tables containing values from both the tables
Hi Miedziu,
Thank you for reaching out to Microsoft Fabric Community Forum.
Possible Causes of Missing Data Based on Your Scenario
- One possible issue is missing or mismatched relationships. Ensure that iEBS 5 and iEBS 6 exist in both related tables and match correctly on the key columns.
- Another reason could be Row-Level Security (RLS). If applied, it might filter out iEBS 5/6. Test by disabling RLS via "View As" in the Modeling tab.
- Lastly, check for filters on visuals, pages, or reports. Filters or slicers might be unintentionally excluding the new values.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu