topic Re: Matrix visual missing 2 rows when uploaded to Report server in Report Server

Matrix visual missing 2 rows when uploaded to Report server

Gayathri_31 — Tue, 28 Jan 2025 15:22:04 GMT

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!

Re: Matrix visual missing 2 rows when uploaded to Report server

lbendlin — Tue, 28 Jan 2025 17:27:36 GMT

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

Re: Matrix visual missing 2 rows when uploaded to Report server

Gayathri_31 — Wed, 29 Jan 2025 10:55:49 GMT

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.

Re: Matrix visual missing 2 rows when uploaded to Report server

lbendlin — Wed, 29 Jan 2025 23:25:16 GMT

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

Re: Matrix visual missing 2 rows when uploaded to Report server

Gayathri_31 — Thu, 30 Jan 2025 07:55:46 GMT

Thank you. I will raise a ticket then

Re: Matrix visual missing 2 rows when uploaded to Report server

Gayathri_31 — Thu, 30 Jan 2025 11:05:54 GMT

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-in-Power-BI-Report/m-p/3994778

Re: Matrix visual missing 2 rows when uploaded to Report server

rohit1991 — Tue, 08 Jul 2025 12:08:13 GMT

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:

Data-Level Filters
- Check Filters Pane for hidden filters in Report Server.
- Ensure no RLS (Row-Level Security) is applied.
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.
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.
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.