Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
burcinkermen
Advocate II
Advocate II

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.

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

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

vjianpengmsft_0-1719468135880.png

Then close Step Layout:

vjianpengmsft_1-1719468498484.png

The display on the Report server is as follows:

vjianpengmsft_2-1719468565497.png

 

 

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.

 

 

 

View solution in original post

23 REPLIES 23
jamie5
Frequent Visitor

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

Aswini000000000
Frequent Visitor

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

Kind regards
EW24

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
Community Support
Community Support

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

vjianpengmsft_0-1719468135880.png

Then close Step Layout:

vjianpengmsft_1-1719468498484.png

The display on the Report server is as follows:

vjianpengmsft_2-1719468565497.png

 

 

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
EW24

EW24
Frequent Visitor

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
Regular Visitor

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

Nogabay
Frequent Visitor

Anyone know when this issue is expected to be resolved?

alarojalill
Frequent Visitor

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.

alarojalill_0-1718352887453.png

 

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
Advocate I
Advocate I

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
New Member

Our reporting team is also seeing this issue.

alexdegti
Regular Visitor

Hello, same problem

CubeInCube
Regular Visitor

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.

PBI_Bug-2024-06-11_11-44-02.png

Anonymous
Not applicable

Hi @burcinkermen ,

There is a new version for PBIRS May 2024, please try to install and try again.

vbinbinyumsft_0-1718072616426.png

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.

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

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
Frequent Visitor

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


Hello,

 

I have the same problem !

 

Best regards

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.