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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

18 REPLIES 18
Aswini000000000
Regular 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.

 

 

 

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

v-binbinyu-msft
Community Support
Community Support

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.

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

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

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

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors