Forum Discussion
Combine Files no longer working
UPDATE: Thanks all for your helpful replies on this, and your most recent post, El_Conquistador
It was solved in the end: I realised if I had one of the spreadsheets I wanted to combine actually open when I had the Power Query window open, the combine function would fail as per above. But once I closed the spreadsheet, it worked!
Only discovered this fortuitously . I often had one of the spreadsheets I was trying to combine open so I could see better the columns I was working with. Hope that helps others with this same issue.
Just a thought.
Can it be a RAM and processing power issue? As you mentioned about High usage on Task manager. Can you try it on another device where RAM and processing power are more than your current device?
or maybe try scripting outside PQ to combine the files then add to PQ. I am not certain that it is the option but just an idea.
or maybe use PBI Dataflow if that's an option.
Hi, it might be a ram issue, don't know. It's not something i can solve though, I'm stuck with the machine I have.