Forum Discussion
Data doesn't display after defined transformation steps
Hi,
lbendlin and Anonymous , the step I have for filtering out header rows is because all the files have the same header. the step prior is promoting the first row as the header and then i filtered one of the columns that had a header value and excluded that from the content. in preview mode, this showed what i wanted.
I had to do two steps for the text column date/time to date change because doing a change from text to date was giving an error and the only workaround for this was to split it into two steps to display just the date.
lbendlin I don't know what you mean when you say using binary.combine loads the first file twice. I'm not seeing duplicates. Can you explain what you mean when you say "implementing your own combination process." how would I do that in power query if this isn't the right way?
Examine the code that Power Query created for you. Once you understand it you can throw it away and implement your own version.
I should have said "reads the first file twice". It is only loaded once.