Product:
Microsoft Excel 365 32 bit version
Microsoft Windows 11
Issue:
Inside a excel report, you have a power query that get data from a other excel file on sharepoint.
When you do refresh to update you get a error.
Possible cause:
The Excel file have to many rows.
When using Excel, it’s important to note which file format you’re using. The .xls file format has a limit of 65,536 rows in each sheet, while the .xlsx file format has a limit of 1,048,576 rows per sheet. For more info, see File formats that are supported in Excel and Excel specifications and limits.
If you load a csv file, you may only get a part of the rows of data. And the sum result may not be what you expect, if you reach a limit in excel program.
More Information:
The Excel Row Limit is 1,048,576 Rows | Row Zero
Loading CSV/text files with more than a million rows into Excel – Jose Barreto’s Blog
https://flatfile.com/blog/top-6-csv-import-errors-and-how-to-fix-them/