topic Re: Unavailable to Export Data with Current Layout - Power BI Report Server in Report Server

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

Anonymous — Mon, 07 Nov 2022 16:00:05 GMT

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

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

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

AgnesB — Tue, 08 Nov 2022 08:07:22 GMT

We experience the same issue. Report Server September 2022, and there is no way to activate the grey layout export setting. We have checked in the report settings, and it does not matter which of the first two options are activated, current layout export is still not possible.

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

mdx2 — Wed, 09 Nov 2022 21:25:01 GMT

We have the same need here and... the same issue with Power BI Report Server Septembre 2022 and Power BI Desktop September 2022.

When we use Power BI Service, the option is not greyed with our basic matrix but when we publish it on our Power BI Report Server, the option is greyed out.

Can you please help @Petebro, @Anonymous ?

Michael

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

Petebro — Wed, 09 Nov 2022 22:01:00 GMT

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.

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

rachelgomez1234 — Thu, 10 Nov 2022 05:00:33 GMT

Microsoft Office treats capsule files from Tally.ERP 9 as unsafe, and prevents export to MS Excel.

Solution
To resolve this issue, change the Trust Center settings in MS Excel to mark Tally.ERP 9 as safe.

To change Trust Center settings in MS Excel

1. Open MS Excel.

2. Click the FILE menu.

3. Click the Options tab.

4. Click Trust Center in the pop-up window that appears, and then click the Trust Center Settings button.

5. Click Trusted Locations , and then c lick the Add new location button.

6. Enter the Path where Tally.ERP 9 has been installed on your computer. Select the check box Subfolders of this location are also trusted , and click OK .

7. Click OK in the Trust Center screen to save the settings.

This may help you,

Rachel Gomez

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

mdx2 — Thu, 10 Nov 2022 08:21:36 GMT

Thank you @Petebro for your reply.

We will be patient for January release :-).

Is there any known roadmap for this next release ?

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

Anonymous — Mon, 14 Nov 2022 09:18:59 GMT

Thank you @Petebro , for this information.

We will be very attentive to the January release

Is there any known roadmap for this next release ?

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

Anonymous — Mon, 14 Nov 2022 09:23:57 GMT

Thank you @AgnesB for your reply.

As @Petebro said, this feature is not available yet in PBIRS. This should be addressed and work in the January PBIRS release next year 🙏🤞

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

Anonymous — Fri, 27 Jan 2023 14:26:56 GMT

OK, I'm in Jan23 version.... and I'm with the same problem =/

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

RayLei — Sat, 28 Jan 2023 02:57:14 GMT

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?

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

Anonymous — Sat, 28 Jan 2023 03:24:28 GMT

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

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

RayLei — Sat, 28 Jan 2023 03:32:51 GMT

This problem was solved on Jan 27th.

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

Anonymous — Sat, 28 Jan 2023 03:44:01 GMT

我看到的依然是2022年1月版本，我哪里做错了？

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

Anonymous — Sat, 28 Jan 2023 03:45:51 GMT

能给我个正确的链接吗？

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

RayLei — Sat, 28 Jan 2023 03:50:40 GMT

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.

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

RayLei — Sat, 28 Jan 2023 03:53:12 GMT

pls try this. https://www.microsoft.com/en-us/download/details.aspx?id=55329

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

Anonymous — Sat, 28 Jan 2023 03:58:14 GMT

谢谢，但是这个依然是2022年1月版本。

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

v-alipat — Sat, 28 Jan 2023 17:00:31 GMT

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

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

RayLei — Sun, 29 Jan 2023 08:48:22 GMT

Hi Alexandra,

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

Best regards,

Ray

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

MikeCopp — Thu, 02 Feb 2023 20:23:23 GMT

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