Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
80
Views
Topic starter
Hi,
I have come across a Power Query issue. And was wondering if there were any solutions to it?
Issue - I have created 2 queries from 2 separate csv files. And have load them on a third xlsm file.
I then tried to append these 2 queries, and then load it. But it has about 4 million rows (literally). I then stops and says it cant load that more memory is needed.
My question is - is there anything i can do other than deleting non-essential rows on the csv files before loading them to PQ? So that it can be smaller and then be able to load to a tab in the workbook?
Please help?
Thank you
Cele
Posted : 02/02/2019 11:54 am
Hi Cele,
The Excel worksheet only has 1,048,576 rows, so you'd have to load this as a connection only and put it in the Data Model/Power Pivot.
Mynda
Posted : 03/02/2019 9:53 pm
