Matrix visual missing 2 rows when uploaded to Report server

[Gayathri_31]

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!

[rohit1991]

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.

[Gayathri_31]

I have seen a thread mentioning the same problem. It is said that this is because of a problem with the Power BI report server version. I am using May 2024 version. Has anyone expereienced the same?
https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-Tabular-Layout-for-Matrix-Visual-...

[lbendlin]

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

[Gayathri_31]

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]

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

[Gayathri_31]

Thank you. I will raise a ticket then