Log In
Register
Home
February 4, 2019
Offline
Hi Mynda,
I have already completed your Power Query course, but please help with a challenge I'm having:
In Power Query in Power BI, I created a query to tranform data using Get File from Folder. I started with only one file (Aug data) to build my query and visualisations. (I realise that I would have to go back to filter out headings) I have now received a 2nd file, (July data) to test the query. I am getting an error at Invoke Custom Function level.
Under Content column there are two binary files, under Transform File column, first files is table, 2nd file is error.
The two files have identical column names and identical sheet names.
The Transform file helper query is working and uses Aug as the example file.
How do I fix this error, please?
Thanks
Tracy.
July 16, 2010
Offline
Hi Tracy,
Difficult to say without seeing your files. If I were you, I'd copy the M code from your query, then create a new query using Get Files > From Folder. Perform the steps up to the point where the files are combined, then paste in the M Code from your original query from the same point onward.
In other words, recreate the Get Files > From Folder part of the query from scratch.
Mynda
February 4, 2019
Offline
Hi Mynda,
Thanks for the advice. The issue actually sorted itself out - it's a mystery. I think it had something to do with saving all attachments from outlook, since when I opened the data files and resaved them, then refreshed data inside the query, it seem to come right. Very weird.
Thanks
Tracy.
1 Guest(s)
