User Missing Subset of Data in Table/Chart

[mkinde]

I recently had a user come to me with an issue where they are missing partial results in both a table and a chart. This information is not missing in my own setup (my results are on the right).

The underlying data for the missing information is in a separate table from the other measures but both tables are processed and stored in the same location and brought into the data model.

How would I begin investigating this? Is this a permissions issue?

[v-kpoloju-msft]

Hi @mkinde,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to @lbendlin, for his inputs on this thread. Here I mentioned few troubleshoot steps please go through the below are that might be resolve the thread.

From what you described and the image comparison, it seems the user may be affected by a filtering or security rule that you aren't. Most commonly, this could be due to Row-Level Security (RLS) being applied, or differences in slicers or filters in their report view.

I would recommend checking if RLS is applied to their account and have them try resetting their slicers and filters using “Reset to default” on the report. If that doesn’t work, also double-check if both of you are working on the same version of the report and that the data model relationships are correctly active for the affected table.

Also please have a look into those links which I provided below:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Tour the report Filters pane - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[danextian · Accepted solution]

Hi @mkinde 

The user may have filters applied without realizing it. Try comparing results after both of you reset the report to its saved state. Also, make sure the user is looking at the same report, as they might be viewing a different or personalized copy.

[lbendlin]

first step is to have them hover over the filter icon in the header icons list, and then compare the filters they see with the ones you see.

[mkinde]

This suggestion was essential to the investigation. Thank you.