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 ,

 

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

 

Thank you.

 

fsinclair's avatar
fsinclair
Frequent Visitor
10 months ago

I have a support call, they haven't got back to me. Assume if I haven't posted or accepted a solution, that I don't have one 👍

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

    Hi fsinclair ,

     

    Thank you for informing me that you have not yet received a response. Please continue to monitor the forum for further updates..

    Thank you,

    Tejaswi.