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 upload the report to the report server, 2 of the rows are missing. How is it possible? How can i correct this? 

Thanks in Advance!

6 Replies

  • Are they missing at the top, at the bottom, or somewhere in between? What timezone is your report server running on?

    • Gayathri_31's avatar
      Gayathri_31
      Frequent Visitor

      The actual matrix I want is as shown in the first picture, but how I see it in the report server is shown in the second picture. I think it is not actually missing, it is changing to compact mode. The layout which I have chosen is tabular, I have also tried with outline. but nothing works. 




      • lbendlin's avatar
        lbendlin
        Super User

        Sounds like you want a tabular layout. If that is not working on  Report Server then you may want to raise a ticket.

  • 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.