Forum Discussion

Gayathri_31's avatar
Gayathri_31
Frequent Visitor
1 year ago

Matrix visual missing 2 rows when uploaded to Report server

Hi Everyone,   I have created a report with multiple pages and visuals in it. 2 of the pages contain matrix visual and I can see all the rows and values in the deskop version. Whereas, when I uploa...
"Power BI Report Server "
Matrix Visual
rohit1991's avatar
rohit1991
Super User
1 year ago

Hi Gayathri_31 ,

Your matrix visual shows all rows in Power BI Desktop, but some rows disappear when uploaded to Report Server.

Possible Causes & Fixes:

  1. Data-Level Filters

    • Check Filters Pane for hidden filters in Report Server.
    • Ensure no RLS (Row-Level Security) is applied.

  2. Report Server Version Issue

    • Ensure Power BI Report Server is updated to the latest version.
    • Features in Power BI Desktop (latest) may not fully work in an older Report Server.

  3. Formatting Differences

    • Check if missing rows have blank values causing them to be hidden.
    • In Matrix Settings, set "Show Items with No Data" to ON.

  4. DAX Measures or Aggregations

    • Verify if measures exclude certain data due to missing relationships.
    • Test with a Table visual to see if all rows exist in Report Server.