Data doesn't display after defined transformation steps

[ce138867]

Hi All,

I've been reviewing multiple different videos and posts regarding how to update a table with monthly csv files that are placed in a sharepoint folder. 

https://youtu.be/mYkNDdjbFvo

https://youtu.be/661LLNtNJEE?si=Cni5ayuuJvNBXGH7

However, when I close powerquery, and return to the report view, there's no data loaded. 

Applied Steps: 

Set Source = Sharepoint root folder

Filtered to the specific folder with csv files

Used a binary.combine function to combine the files

Promoted Headers

Filtered out Header Rows

Changed Text columns to Date/Time

Changed Date/Time to Date

Renamed Query1 to a Table1

Updated Sample File Source = Table 1

It's not pulling in any data. What have I done wrong?

Thanks in advance

[v-heq-msft]

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

[ce138867]

Hi,

@lbendlin and @v-heq-msft , 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?

[lbendlin]

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.

[lbendlin]

Filtered out Header Rows

please elaborate.

Also note that when you  binary.combine it will take the meta data from the first file (and load the first file twice).  You would want to avoid that by implementing your own combination process.