Forum Discussion
Data doesn't display after defined transformation steps
Hi ce138867 ,
As lbendlin said, you mentioned filtering out the header rows, make sure this step is not accidentally removing all data. Please double check the configuration of this step. Also, you need to make sure that changing the text column to date/time and then back to date should not be a problem, but please make sure that this conversion is done correctly and does not cause any errors.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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.
