Forum Discussion

mkinde's avatar
mkinde
Frequent Visitor
1 year ago
Solved

User Missing Subset of Data in Table/Chart

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?

 

 

 

Need Help
  • danextian's avatar
    danextian
    1 year ago

    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.

     

     

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    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's avatar
      mkinde
      Frequent Visitor
      1 year ago

      This suggestion was essential to the investigation. Thank you.

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    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.

     

     

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    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.