Missing Values when uploading whole folder of csv files

[ranz_vincent]

Has anyone encountered null values when uploading data in pbi. I've noticed missing values when building my report and found out that I am having errors due to null values, and when i check the source file it was complete no blanks or errors, after that I tried uploading one single csv file that has null values and it was complete. Does anyone have a solution for this? 

https://drive.google.com/drive/folders/1k7KeQTkI-ZScgcr2m8_uZgL9E36D4Km-?usp=sharing 

[ranz_vincent]

I've may have found the problem some headers are different making thus making some values null any work around this because I have multiple files and it would take time for me to manually cleanse those files.

[danextian]

But how different are they? Power BI uses the headers to group the data vertically.

[ranz_vincent]

Some headers have extra spaces like dc_code and store_code and some and some are entered as date_departure but it shoul be date_dispatch

[danextian]

The automatic combine and transform feature can't help you with that. It's for the basic of combining files. The trailing and preceding spaces can easily be removed with custom M but for departure and dispatch date, what if there are files with both columns?

[danextian]

Hi @ranz_vincent 

I am assuming you used the automatic combine and transform feature. This feagture uses to QuoteStyle.None which may be the reason why you're missing some values. Use  QuoteStyle.Csv instead

More  on that: https://learn.microsoft.com/en-us/powerquery-m/quotestyle-type 

Otherwise, please identify which records have missing values.

[ranz_vincent]

I found out that some of headers have extra spaces or different from the usual headers do you think that causes the problem. Do you know any workaround cause I'm not really good at this.