Forum Discussion

AAM_'s avatar
AAM_
Regular Visitor
1 hour ago

Error while exporting Excel using the "Summarize Data" option.

Hi,

When trying to export to Excel, some users are receiving the following error message:

No changes have been made to the report or to the underlying data model. However, starting today, some users have begun encountering this error.

The issue does not occur consistently, and it is not associated with any specific combination of measures and dimensions.

We are unsure what could have caused such a sudden issue.


thanks!

Need Help

1 Reply

  • DreamITLearn's avatar
    DreamITLearn
    Icon for Advocate I rankAdvocate I
    44 minutes ago

    Hi AAM_​ ,

    This is a known, recurring issue with Summarized Data export ("File couldn't be created" / query generation error) that others have reported too, it isn't something specific to your environment. A few things worth checking since it started suddenly with no report changes:

    1. Confirm whether it's tied to visuals pulling measures from multiple tables, that's the most common trigger per the error message itself.
    2. Check if it only fails with the "xlsx with live connection" export option specifically, other formats (CSV, current layout) often still work as a workaround.
    3. Rule out a recent service-side update, this error has appeared in waves for other users right after Microsoft backend changes, not local report changes.

    If it's intermittent and not tied to a specific visual, it likely points to a service-side issue rather than your data model. Worth checking the Fabric/Power BI service status page for any known incidents around the date this started.