Missing values when using a folder as a source

[davidibarrag]

Hello everyone, i got one problem. I realize that when I connect the power query to a folder with csv files and combine them, there are a lot of missing values. But when I connect each file independently, those missing values appear. Do everyone know how to solve this problem, i could use a lot of help here. I can´t connect each file alone because there are like 100 files. 

Thank you a lot.

[v-eachen-msft]

Hi @davidibarrag ,

Please make sure that the columns( regardless of name or format ) of these files are same. 

If it is not a problem caused by this reason, you could show more details with files and screenshots.

[AlB]

Hi @davidibarrag 

Can you perhaps share some of the files in the folder and the M code you are using so that we can replicate the issue?

What kind of values are gone missing? Is it a specific data type?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers