Forum Discussion
Power Query Editor Transform file helper Query folders
Unfortunately this is not working for me
"Click the first Binary link. That ingests the CSV
and already promotes the headers"
It doesnt do this. You have to click the arrows on the data column to bring through the data atfter clicking on Binary. And you have to do the column promotion youself.
the other thing it doesnt bring through because you are clicking on one file only is the actual file name.
Has anyone got another option I can use that will bring through the filr name. Which is what happens when you filter for the foles and then click on content to bring both files through?
Please provide a couple of sample CSV files (with the same structure).
Sorry i cant do that its not my data.
Hopefully this walk through gives me what I need https://youtu.be/6cGou1-1FOo
Yes, this video works a treat