Remove 2MB excel data source file limit

[Rhemo]

Kept getting an error when attemting to connect to an excel data source with the following error

File size above allowed value. File size:4570080, AllowedFileSize (in Bytes): 2000000

It is a multi sheet excel file with each sheet having table that i was attemping to connect to. It only connected to some of the tables. These were only going to be used as information retrieval no table was over 500 rows and would also not be written back to.

Could you please consider upgrading the file limit?

Many thanks

[mkujalowicz]

I totally agree. I'm pulling data from a Model done in PowerQuery and my source table has no more than 400 rows, however, underlying queries and the model make the file of 2.5MB size. I think this limitation stops PowerApps users to create their data sources in a more sophisticated way than static Excel tables.

Regards,

[FoDelement]

2MB?! What is this, 1996?  I am working with a large spreadsheet that contains 20K+ rows, but a table that only has 100. But since my other data makes my spreadsheet 2.3MB I can’t use it?!

PLEASE increase this, or atleast give us the option to. 

[NIckCUK]

Seems a very limiting feature - I have just hit this same problem !    Arggghhhh

[FoDelement]

@NIckCUK 

You're are at the start of something I already finished, so I'll give you some more info.

Powerapps, by default, can only read the first 500 lines of a table. 

You can increase this by going to app settings, but it still has a hard limit of 2000.

What I ended up doing is pulling the report. (30k + lines) and creating a macro that would delete colunns and rows I didn't need. Then it created a table every 2000 rows, and pasted my data into them.

The final "gotcha", is powerapps creates a column and fills it with a "powerapps ID". So if your data source really close to the 20000 limit, once you add it as a source the first time, it will end up being too big anyway

It's not pretty, but it works.

[NIckCUK]

@FoDelement - I think the limit is overall file size rather than table size, as the excel matrix I inherited has all 42 tables below 500 lines

[FoDelement]

@NIckCUK 

There is a limit on both, sadly. 

---

[mkujalowicz]

Btw,

I was searching in the Microsoft documentation the info re the limitations of Excel source data and very few sources mention this limitation and in my opinion it's one of the first things to know before creating your data model in Excel.

Cheers

[James_Schmehl]

Yeah 2MB is laughable.  Betcha Apple has better tools...

(coming from an Anti-Apple guy)

[FoDelement]

Please just give us at least 5 MBs!

Or allow Binary file format.

[mkujalowicz]

Hello,

I'm following this article's best practices to limit the size of the Excel file.

https://support.office.com/en-us/article/create-a-memory-efficient-data-model-using-excel-and-the-po...

Cheers!