Forum Discussion
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
- lbendlinSuper User
Are they missing at the top, at the bottom, or somewhere in between? What timezone is your report server running on?
- Gayathri_31Frequent 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.
- lbendlinSuper User
Sounds like you want a tabular layout. If that is not working on Report Server then you may want to raise a ticket.
- Gayathri_31Frequent Visitor
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 - rohit1991Super User
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.
-