Connecting and combining from a Onedrive folder

[Anonymous]

Hello,

I'm trying to connect and combine a folder holding multiple years of data into Power Bi.

My years of data can be about 100-200KB each

I have found an issue where I can not connect and then combine this data into one because the files are so big.

I've begun to split my years up into months so that I can combine but I've found that any file bigger than 45MB is considered too big and throws back an error message. This doesnt help as some months are bigger than this!

Anyone know a way around this?

Thanks!

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may check if the following post helps.

https://community.powerbi.com/t5/Power-Query/Data-Refresh-Error-Request-Entity-Too-Large/m-p/56460#M4717

[Anonymous]

Hi,

Thank you for the reply. My Excel spreadsheets are below the threshold which is bizarre but I think it is down to my employer internet restrictions.

I'm happy mark this as a solution as I may never know the reason it does it but I'm happy with the way things are the way forward so thank you!!