Forum Discussion

Miedziu's avatar
Miedziu
New Member
1 year ago
Solved

Inconsistency in data

Hello, I'm struggling to understand what's happening in my report. I recently added some data to my database and loaded it into Power BI. For some reason Power BI can't see this data properly. It wor...
  • Anonymous's avatar
    Anonymous
    1 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

  • Bhavnish's avatar
    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