Forum Discussion
Solved
Inconsistent file transformations from combine file in Dataflow
I have an existing dataflow where the source is set to a Sharepoint folder. The dataflow then filters for the CSV file with the most recent "creation date" and I used the "Combine file" option to exp...
Follow these steps:
- go to the "Transform file from Query" > "Helper Queries" > (query) "Transform Sample File"
- Find the Source step and in the formula bar remove the "Columns = 20," from the code
This change will make sure that you always get all the columns from every single file. It won't be set to a specific number of columns anymore.
Hi!
Could you please share the Power Query Script (M code) of your exemplar query (sample transform query)? That would help us understand what logic you have implemented.