Issue Export Summarized Data & Fields Parameter

Hi,

We are experiencing the same issue, and it is now affecting all users.

Has a solution been provided to you?

Hi, I am also getting the same issue on export. What is the solution to it ? Has Microsoft shared any fix for this problem ?

Hi pinellus​,

Thank you for reaching out to Microsoft Fabric Community.

Thank you ShivekMaharaj​, Rom_Cheng​ and gmunoz​ for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? Is your issue resolved? or have you raised a support ticket?

Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Thanks and regards,
Anjan Kumar Chippa

We see the same issue since a few days ago. One thing I notice is that, if you press F5 to refresh the page, and then you may export successfully once, and then the issue will happen again until you press F5 for another time. This seems very likely a matrix visual related issue and I can export successfully from another visual such as barchart. Hopefully we can get some information from Microsoft soon.

Hi pinellus​ ,

That’s a very useful isolation test. If the static version of the matrix exports “Summarized data” successfully, that would make the Field Parameters interaction a much stronger suspect.

As a possible workaround while this is being investigated, you could also bypass the visual export pipeline entirely. With Power Automate, Run a query against a dataset can query the semantic model directly using DAX, so you can reproduce the required tabular result without relying on the visual’s “Summarized data” export.

It requires a bit more setup, especially if the Field Parameters need to remain dynamic, but it could be useful if you need to get the data out while the issue is being investigated.

I wrote up this approach, including the DAX and Power Automate steps, here:

https://blog.hogaria.tech/de-power-bi-al-correo-sin-capacidad-premium/

The article is currently in Spanish, but hopefully automatic translation makes it useful.

I’d still report this to Microsoft Support as a potential regression, since the fact that it worked until 11 September without any report or model changes is quite telling.

Hi pinellus​,

Based on the isolation you have already done, I think a service-side regression is a reasonable suspicion, although I wouldn't call it confirmed yet.

Microsoft's current Export data documentation states that Data with current layout and Summarized data have the same data granularity; for a matrix, the main difference is that Current layout preserves the matrix shape while Summarized data produces a flat table.

That makes your result interesting: if Current layout still exports successfully from the same visual while Summarized data suddenly fails for all users, the problem seems more specific to the summarized-data query generation than to export permissions or the model generally.

I also don't see standard summarized export listed as an unsupported scenario in the current Field Parameters limitations.

One test I would try is duplicating the matrix and temporarily replacing the three Field Parameters with the physical fields/measures currently selected by those parameters. If Summarized data succeeds on that static version, that would isolate the Field Parameter interaction quite strongly.

Given that the same report worked until 11 September with no report/model changes, I would keep using Data with current layout as the temporary workaround and raise this with Microsoft Support with the failing visual, timestamp and error details. Microsoft now publishes active Fabric issues through the Fabric Support known-issues experience.

So I think your regression hypothesis is plausible; I just wouldn't state it as confirmed until Microsoft acknowledges the issue.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.