Embedded Report: Executing the Query for the Export Data operation resulted in an error.

Hi fsinclair ,

Thank you for reviewing this issue across Desktop, Service, and SharePoint. Since the error occurs in all environments, it appears to be related to the export query rather than an embedding limitation.

Export queries can become complex, especially with calculated columns, measures, relationships, or filters. To help isolate the issue, please try exporting a simple table without filters. In Desktop, enabling Performance Analyzer can help identify if a specific calculation is causing the error.

Given that your data source is an Excel file on SharePoint accessed via a web link, certain Power Query transformations such as renaming columns, changing data types, or merging tables may be contributing to the problem. Testing an export from a basic table with raw columns and no transformations or measures can help determine if this is the case.

Additionally, recent changes to how Power BI Service manages export queries may impact certain functions or complex DAX logic. If the issue persists with a basic visual, it could indicate a service regression or bug.

As a temporary solution, consider using the Analyze in Excel feature (if available), creating a simpler export-friendly table for users, or utilizing DAX Studio to extract the required data directly from the model

Given that the issue affects all environments and is not exclusive to SharePoint, I recommend submitting a support ticket to Microsoft : How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 for further investigation. Please include the error message screenshot, confirmation of failure across Desktop, Service, and SharePoint, and the steps to reproduce using your sample file. This will assist Microsoft in determining if the problem is related to a service-side change.

Thank you,

Tejaswi.