Forum Discussion
fsinclair
10 months agoFrequent Visitor
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, ...
- 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.
fsinclair
6 months agoFrequent Visitor
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.