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.
I have tried getting the data from scratch ie. using the Get Data from Folder option in the menu bar at the top, but that also fails when I try to load and transform 😞
I know this is an old thread however, I know what the issue is. If the folder your trying to get data from has an invalid character, especially # a hash tag at the front of the folder name, this issue will occur. Hopefully this will save others time and hassle when this problem occurs.