Applies to Product - Microsoft Dataverse
What’s happening?
The customer encountered an error message stating, "This operation failed because we couldn't connect to the server. Please try again later," while attempting to export a large dataset (50,000 records) to Excel.
Reason:
This is likely related to limitations in the number of rows and columns that can be exported, which may be affected by network bandwidth and server traffic at the time of the operation.
Resolution:
- Reduce the number of rows or columns in the dataset being exported to decrease the total number of cells. The recommended number of columns for 500,000 cells is 5 columns.
- If the issue persists, consider checking the throughput of the environment to ensure it can handle the export operation.
- For exporting large datasets, consider using alternative mechanisms such as Athena for better scalability and performance.