Answered

OneDrive 2MB Excel data source file limit

(0) Share

Report

Posted on by jayceeb

Hi, Is the 2MB file size limit for OneDrive Excel as data source still the same?

Do we have an option to change it? currently we purchase a PRO license as advise that we can store data more than that but the app was done before we purchase the PRO license.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jayceeb

Yes, the 2MB limit still applies if you use the OneDrive connector.

If you use the 'OneDrive for Business' connector, the limit is greater. To use this, you would need to be using 'OneDrive for Business', rather than a 'personal' OneDrive location.

Was this reply helpful? Yes No
jayceeb 88 on at

Like (0)

Report

so, what is the other solution? we still cannot adjust the file size ☹️

Was this reply helpful? Yes No
Verified answer

timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report

@jayceeb

Unless you store your Excel file in OneDrive for business and use this connector, there is no real solution to the 2MB limit.

https://learn.microsoft.com/en-us/connectors/onedriveforbusiness/

If you store your file in OneDrive and use the OneDrive connector, the only other alternative is to split the tables in your Excel file into multiple Excel files that don't each exceed 2MB in size.

https://learn.microsoft.com/en-us/connectors/onedrive/

Was this reply helpful? Yes No
jayceeb 88 on at

Like (0)

Report

sad. 😞 we're relying in excel as we connect to different files but it seems that even if you're using a pro license still not possible to adjust the file size limit. thanks

Was this reply helpful? Yes No