Excel workbooks are one of the slowest data sources you can use with Power Query in Excel or Power BI. Reading small amounts of data from small workbooks is usually fast; reading large amounts of data ...

What causes it? TL;DR it’s because you’re trying to load data from one type of file, probably Excel (I don’t think you can get this error with any other source ...

Standard Excel tools can usually get the job done, but they often lack the resilience and flexibility needed for complex data and transformation tasks. Power Query doesn't just perform these tasks ...