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, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Unavailable to Export Data with Current Layout - Power BI Report Server

Hi all,
After the last update of Power BI Report server, version 2.109.1021.0 (septembre 2022), I have seen that now there are three options to export to excel, however, the option that interests me to export Data wih current Layout is disabled

DanielaM_0-1667830891160.png

 

I have created a simple report with a visualization type matrix, and I am already considering all the posts I have seen to export matrices : 

"- Matrices with columns and/or values but no rows will be exported as having rows and/or values but no columns

- Matrices with only one row and/or values but no columns will be exported as table (no right border separator)

- If the Show on rows toggle is set to 'On' in Power BI Desktop for a table or matrix visual, the visual format would not be preserved when data is exported to Excel

- f the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu."

 

 

I have published the report in the Power BI Report Server version and when I clic "Export Data" on the matrix I do not have the option available to export Data wih current Layaout.

A colleague published the same report in the Power BI Services version and there the option Data wih current Layout is available.


Could it be that this option is not yet fully developed for Power BI Report Server?

 

Thanks in advance for any help you can give me.

Daniela

2 ACCEPTED SOLUTIONS
Petebro
Microsoft Employee
Microsoft Employee

This is sort of a byproduct of features being developed in different parts of the Power BI orginization and lighting up in different products at different times. Unfortunately, without getting into too detailed of an explanation, it is a feature that is not available yet in PBIRS. This should be addressed and work in the January PBIRS release next year.

View solution in original post

v-alipat
Microsoft Employee
Microsoft Employee

Hi everyone, 

 

Unfortunately, this new feature is still not added to January 2023 release of Report Server, it got delayed.

As Pete mentioned earlier in his reply, that's one of features developed in a different part of Power BI, and we simply didn't get it in RS yet. 

We are following up frequently, and will include the feature as soon as it's ready 😌 

Sorry about the inconvenience. 

 

About the download page - it is a known thing, that it takes more time for files to be updated in some regions. We will look if we can make it faster next time. 

 

Thanks for understanding!

Alexandra  

View solution in original post

38 REPLIES 38
PowerBI_F
Frequent Visitor

Dear,
when can we expect,  Data with current layout in PBIRS, still not able to visible under Version1.19.8779.19175(January 2024), i have enabled report setting option, still not yet, please update us when can we expect? we are facing many challenges when it come to matrix.

 

 

DungDao175
New Member

Until prerent, it not available in Power Bi RS 😔

johnpbi
Frequent Visitor

Any update on this? It seems that this feature is still not available in the January 2024 edition of report server...

anandm
New Member

This feature is still not available in the PBI report server. Could you pls share any updates on the availability of this feature and any workaround to acheive this capability in the mean time?

Petebro
Microsoft Employee
Microsoft Employee

We have investigated this further and it is unfortunately not a trivial implementation for PBIRS due to some technical challenges. It has always been the stance that the Power BI service may get these features that are unique to them when using Power BI reports and this is unfortunately one of those scenarios.

 

If it is critical then we suggest using the Power BI service to do these exports.

 

This feature may come to Power BI Report Server in the future, but it will not be part of the May 2023 or September 2023 releases,

Is it possible to appear in the January 24 version, or is there a relevant roadmap that we really need

Hi Petebro,

 

In our organization, we implemented PBIRS in order to setup folders, with permissions for certain roles within our organization, to have access to certain reports that report builders can distribute to. I understand, with the service, each report must be shared out to groups manually which is why we have not used the service.  The problem of not having the "export with current layout" on PBIRS has halted our implementation of this. 

Petebro
Microsoft Employee
Microsoft Employee

I totally understand your frustration, but this is a limitation that will exist for the near term in Power BI Report Server. It is on our backlog of features, but there are items above it. One suggestion is to add this to Ideas (powerbi.com). This may be able to adjust priorities in the future.

RayLei
Advocate I
Advocate I

This problem is still not fixed in Jan 2023 version😂. Another problem is that when I exported Report Server version Jan 2023 on Jan 25, the exported installation file is Report Server Jan 2022. and this problem got solved one day later. I am wondering how the product is managed, why not fix it within hours?

v-alipat
Microsoft Employee
Microsoft Employee

Hi everyone, 

 

Unfortunately, this new feature is still not added to January 2023 release of Report Server, it got delayed.

As Pete mentioned earlier in his reply, that's one of features developed in a different part of Power BI, and we simply didn't get it in RS yet. 

We are following up frequently, and will include the feature as soon as it's ready 😌 

Sorry about the inconvenience. 

 

About the download page - it is a known thing, that it takes more time for files to be updated in some regions. We will look if we can make it faster next time. 

 

Thanks for understanding!

Alexandra  

Hi - Is this feature added in the May 2023 PBIRS release?

Petebro
Microsoft Employee
Microsoft Employee

No it is not. This was commented on in other places and added to the unsupported features docs. Currently it is not able to be supported on PBIRS due to technical limitations. If this scenario is critical the advice is to use the Power BI service itself.

Thanks for the quick reply.

Is there a link to the roadmap to be notified when this feature will be released? Our organization requires the export with current layout.

Hi Alexandra,

Thank you for prompt reply and clear explaination. Waiting for good news from you and Power BI team.

 

Best regards,

 

Ray

Anonymous
Not applicable

下载依然是2022年1月份版本?

This problem was solved on Jan 27th.

Frankly speaking, the most expected exported with current layout feature is not fixed. There Version Jan 2023 does not have any new feature attracting me, cause I use SSAS as data source, can not benefit from modeling improvement.

Anonymous
Not applicable

能给我个正确的链接吗?

Helpful resources

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

October NL Carousel

Fabric Community Update - October 2024

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