Forum Discussion
Issue with Tabular Layout for Matrix Visual in Power BI Report Server (Version 1.20.8910.25479)
Hello,
I am encountering an issue with the matrix visual's tabular layout in Power BI Report Server. In the May 2024 release of Power BI Desktop RS, the option to set the "Layout" to "Tabular" was introduced. When I configure the layout to "Tabular" in Power BI Desktop RS (May 2024), the visual displays correctly.
However, after publishing the report to Power BI Report Server (Version 1.20.8910.25479, May 2024), the matrix visual defaults back to the "Compact" layout instead of retaining the "Tabular" format.
I suspect that the current version of the server might not support the updated matrix visual. Has anyone else experienced this issue, or does anyone have insights on how to address this discrepancy?
Thank you for your assistance.
Hi, burcinkermen and everyone,
This is a known issue and is currently being fixed. If your report is affected, please use the Power BI Desktop RS version for January, which you can download by clicking on the link below:
Then close Step Layout:
The display on the Report server is as follows:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
23 Replies
Hello, same problem
I'm having the exact same problem. Existing reports with this visual have retained the tabular layout, but any new reports or re-published existing one lose the tabular layout.
Anyone know when this issue is expected to be resolved?
Hi, burcinkermen and everyone,
This is a known issue and is currently being fixed. If your report is affected, please use the Power BI Desktop RS version for January, which you can download by clicking on the link below:
Then close Step Layout:
The display on the Report server is as follows:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
There is a new version (15.0.1115.206) date 27 July 2024, Download Microsoft Power BI Report Server - May 2024 from Official Microsoft Download Center.
The changelog (Change log for Power BI Report Server - Power BI | Microsoft Learn) is not (yet) updated. We'll wait untill the solved fixes are known. We also decided to wait for the fix instead of an 'Roll-back' to the January version.
Kind regards
EW24This version (15.0.1115.206) whas the fix we needed. Matrix in tabular mode works now (same display between file and server). Thanks. Kind regards EW24
Hi burcinkermen ,
There is a new version for PBIRS May 2024, please try to install and try again.
For more details, you could read related document:
Change log for Power BI Report Server - Power BI | Microsoft Learn ,
Download Microsoft Power BI Report Server - May 2024 from Official Microsoft Download Center
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Unfortunately, installing the June 10 bug-fix release of Power BI Report Server did not help resolve this issue.
I have the same problem and the version dated June 10, 2024 ( 15.0.1115.178 ) does not correct the problem. Does anyone know when this bug will be fixed as I have more than 100 reports that have become unusable.
Do you have a way of getting around this problem while waiting for the fix?
Thank you.
Fabien
Hi,
We have still the same issue and use the latest version (Downloaded 2024-06-18 May version 15.0.1115.178). We use the regular Matrix in a on-premise enviroment from Microsoft and it looks like the option switch values to row' is not working properly. In the regular PowerBI version this option it's moved though in the On-premise version it's available under 'Values'- 'Options'. Perhaps this information can help in finding a solution.
Kind regardsEW24
Running the latest versions of both PBI Report Server as well as Desktop (for PBIRS) and I am facing the exact same issue as the OP.
Our reporting team is also seeing this issue.
I am having the same issue. Despite the matrix layout setting (compact/outline/tabular) I choose in Power BI Desktop (for RS), when uploaded to Report Server the matrix visual is shown in compact layout and is not usable. I cannot even see all the row headers and the visual is a proper mess.
The matrix needs to stay in the same layout as in PBI desktop when uploaded to Report Server.
I have installed the latest version: Version: 1.20.8926.40580 (build 15.0.1115.178), Released: June 10, 2024
Please fix this bug quickly. It is a shame that again there are notable issues with the new version. In Sept 2023 there were major problems with custom visuals not working after updating the version (widely used chiclet slicer for example).
Now this. Unacceptable.problem solved ? seems i have the same problem with the lastest server&desktop installed
Have the same issue. Both my desktop and report server is in May 2024 and many reports have this issue as I am not able to edit and publish the layout. If my desktop is in Jan 2024 and server is in May 2024, would it work? I can't seem to find a link to download Jan 2024 Report server version anymore.
Hi,
It would help if you post the version numer of the May releases you use. I always keep both together (Desktop and associated RS). Lets see what other members say about this.
January version is post in the solution (workaround)
Download Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2024) from Official Microsoft Download Center
Kind regards
EW24Hi,
Thanks for the link. I couldn't find the server Jan 2024 version for some reason even after a long search. I had the same version which is mentioned in the post as my desktop.
