Connecting Excel to PowerBI

[rrb92]

I have a bunch of excel files which I want to read into PowerBI. Each sheet is approx 30 MB. Once I do the data processing, the final output/flat file structure is of approx 4M records each sheet. 

I can do two sheets but while doing the third one, I encounter an error midway of my steps of data processing, "Queries can not be proceesed. File size exceeded 10MB limit". 

Please guide me on how can I keep on adding more files. Thank you.

[rrb92]

Thank you for replying. But I am unable to follow the article. Does that mean we can't accomodate this? 

[ribisht17]

* Action Required: You have to do one of two things.  Either enable the workbook in the old Power BI Sites, or use the Get Data action within the new Power BI Dashboard site and get an Excel File that is hosted on OneDrive for Business which allows you to still use the Excel Online app as an option.

[ribisht17]

Hi @rrb92,

https://powerbi.microsoft.com/en-my/blog/power-bi-workbook-size-limitations/

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series