Inconsistency in data

[Miedziu]

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 works for the previously provided data, iEBS 4 in this case but it doesn't work for iEBS 5 for some reason. I've checked many times if there are any additional characters in my database, if there are any abnormalities, I couldn't find anything. 

The column is a calculated column, where it retrieves data from a different table. I've also checked if the measure used for calculating these values works for iEBS 5 and 6 by creating a table visual and I was able to see all the needed values but they're not showing up here. 
Another problem that came up is when I was trying to set up a slicer which is used as a filter. After selecting the column with iEBS 4, iEBS 5 and iEBS 6 values from "table 1" which retrieves distinct values from "table 2", I'm able to see all of them but If I wanted to select the same column but directly from "table 2" it only shows iEBS 4. It's like it's not recognizing the data from this table. All the relationships previously created between my tables seemed to work without any problems. Then, after selecting either iEBS 5 or 6 from the slicer, no data is shown in all my graphs present in my Power BI report.

There's a preview of how this looks for card visuals. 

It works fine for iEBS 4, showing all the required data, no matter if the source of the slicer values are from "table 1" or "table 2", iEBS 4 works, the other don't. I don't know if it's some kind of connectivity issue, is there something I'm missing maybe? 
Any help would be greatly appreciated. Thank you!

[v-vpabbu · Accepted solution]

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

[Miedziu]

Hi, so the issue was the filter on visuals. While it worked fine with previous data, eliminating this one visual filter from other visuals got rid of the problem and it started working perfectly fine. Just by doing "Edit interactions" and disabling the correct one resolved the issue. Thank you for the help!

[v-vpabbu]

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

[Bhavnish · Accepted solution]

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

[v-vpabbu · Accepted solution]

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