Forum Discussion

fsinclair's avatar
fsinclair
Frequent Visitor
10 months ago
Solved

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

    Hi.   I have a dashboard, in which the data source is a web url which links to an excel sheet on an internal SPO page (i did not use the SharePoint Data option when i linked this data, ...
Need Help
  • fsinclair's avatar
    fsinclair
    6 months ago

    After many moons, I have finally found a (frustratingly simple) way around this. 

     

    When exporting from the table view, change the defaults to ‘Summarised Data’ and ‘.xlsx (Excel 150,000-row max)’, then click ‘export'. I have no idea why this works but regular export doesn't.

v-tejrama's avatar
v-tejrama
Community Support
10 months ago

Hi fsinclair ,

 

Thank you for providing the detailed explanation. From your description, the issue does not appear to be related to data size or model type, as you are using Import mode with a limited number of rows. The error is instead originating from the export operation within the embedded context. Due to recent backend updates in the Power BI service, exporting visuals embedded in SharePoint via the web part has become inconsistent. This explains why the functionality was previously working and has now changed in recent weeks.

 

To verify, please attempt to export the same visual directly from the Power BI Service, outside of SharePoint. If the export is successful there, it confirms that the limitation is specific to the embedded SharePoint view. Currently, the recommended workaround is to export directly from the Power BI Service or to share the report through a workspace or app where exporting is fully supported.

 

While I understand this change may be inconvenient, please be assured that your report configuration is correct; the restriction is with the export feature in SharePoint embed.

Thank you,

Tejaswi.