Loading Data From Folder

[Anonymous]

Hello,

I have a report in Power Bi that get data from excel files. Does anyone knows whats is the limit of excel files that Power query supports? or Max lines? or file size?

Many thanks,
David

[Anonymous]

But there is a limit of excel files to upload? Or just a size limit for each one?

[Vijay_A_Verma · Accepted solution]

This limit of 1GB is per Excel file. There is no limit to the number of Excel files but you will be constrained by the amount of memory available to Power BI to process the files. 

[Vijay_A_Verma]

I presume you are talking about Power BI Desktop. Maximum size of Excel file is 1GB for Power BI Desktop.

Described here - Reduce the size of an Excel workbook to view it in Power BI