The maximum file size for any type of data source is 10 MB. Note: A data source is not restricted by the number of rows.
If your file exceeds the maximum size, look into reducing the file size or breaking up the data into more than one file. Here are some suggestions we hope you'll find helpful:
- Save the file as a .csv file type. This makes the overall file size smaller.
- Change the query to retrieve data for a specific date range.
- Change the query to retrieve specific columns of data and not all (*) data.
- Aggregate the data before you run the query.
- Split the content of the file into two or more data sources keeping one column in common.
In addition, for an Excel file type, remove all external references, such as VLookup, as well as any hidden rows and columns.