Announcements
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.
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.
so, what is the other solution? we still cannot adjust the file size ☹️
@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/
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 474
WarrenBelz 375 Most Valuable Professional