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,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Vinay Pabbu