Issue with Tabular Layout for Matrix Visual in Power BI Report Server (Version 1.20.8910.25479)

[burcinkermen]

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.

[jamie5]

I am still experiencing this issue. Using May 2024 Power BI RS version. When will this be resolved?

[Aswini000000000]

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.

[EW24]

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

Kind regards
EW24

[Aswini000000000]

Hi,

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. 

[v-jianpeng-msft · Accepted solution]

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:

Download Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2024) from Offic...

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.

[EW24]

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
EW24

[EW24]

This 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

[neil_peng]

problem solved ? seems i have the same problem with the lastest server&desktop installed

[Nogabay]

Anyone know when this issue is expected to be resolved?

[alarojalill]

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.

[Janie12]

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.

[Dingoes]

Our reporting team is also seeing this issue.

[alexdegti]

Hello, same problem

[CubeInCube]

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.

[Anonymous]

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.

[Aswini000000000]

Is the issue resolved? Tried the workarounds, other than downgrading both my on prem server and desktop to Jan 2024, nothing seemed to work.

[pmi_kr]

The issue seems to be resolved on 15.0.1115.206 (published 12 July)

Unfortunately we have encountered a new issue publishing reports to ReportServer Portal - Item not found exception both for new and replacing reports, so proceed with caution

[EW24]

Hi, Thanks for the update. I hope the MS-team will be so kind to update the changelog. We (I) would like to see a list of all solved sixes. The last update mentioned in the changelog is version 15.0.1115.194.

Change log for Power BI Report Server - Power BI | Microsoft Learn


Kind regards
EW24

[CopinA]

Hello,

I have the same problem !

Best regards

[fabienChery]

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