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

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

burcinkermen — Mon, 10 Jun 2024 06:00:26 GMT

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.

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

Anonymous — Tue, 11 Jun 2024 02:24:18 GMT

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.

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

CubeInCube — Tue, 11 Jun 2024 09:48:27 GMT

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.

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

burcinkermen — Tue, 11 Jun 2024 11:36:15 GMT

Unfortunately, installing the June 10 bug-fix release of Power BI Report Server did not help resolve this issue.

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

alexdegti — Wed, 12 Jun 2024 08:26:42 GMT

Hello, same problem

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

Dingoes — Wed, 12 Jun 2024 16:01:51 GMT

Our reporting team is also seeing this issue.

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

Janie12 — Thu, 13 Jun 2024 10:37:30 GMT

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.

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

alarojalill — Fri, 14 Jun 2024 08:19:44 GMT

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.

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

Nogabay — Sun, 16 Jun 2024 11:09:29 GMT

Anyone know when this issue is expected to be resolved?

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

Gundy21 — Tue, 25 Jun 2024 19:59:01 GMT

If you can live with the table visual instead of the matrix visual until Microsoft fixes the bug, the table visual works.

I uninstalled the desktop application and installed the January version and it works!!! even with the server on the newer May version. give it a try.

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

EW24 — Thu, 20 Jun 2024 09:31:35 GMT

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 regards

EW24

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

fabienChery — Fri, 21 Jun 2024 08:36:21 GMT

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

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

neil_peng — Tue, 25 Jun 2024 08:43:10 GMT

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

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

Anonymous — Thu, 27 Jun 2024 06:10:07 GMT

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 Official Microsoft Download Center

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.

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

Aswini000000000 — Tue, 02 Jul 2024 13:23:26 GMT

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.

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

EW24 — Tue, 02 Jul 2024 04:36:34 GMT

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
EW24

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

Aswini000000000 — Tue, 02 Jul 2024 12:53:15 GMT

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.

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

CopinA — Fri, 05 Jul 2024 11:20:44 GMT

Hello,

I have the same problem !

Best regards

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

Aswini000000000 — Tue, 09 Jul 2024 14:21:44 GMT

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

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

EW24 — Wed, 17 Jul 2024 13:22:05 GMT

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