Forum Discussion

kylon_19's avatar
kylon_19
Frequent Visitor
6 years ago
Solved

From Folder Connector Converting Some data to Null

Hi All,    I am trying to join a series of CSVs that all follow the same structure and have the same headings into a data model using power query (get data > folder method).   It is pulling data ...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    How can a CSV file have binary data? It should be pure ASCII.

     

    You also want to make sure the file formats are actually the same. ASCII and ANSI are different, and some may have a CR/LF at the end and others a CR. 

    When pulling in a CSV file you can change the type it is.

     

     

    I'd pull a few of those in manually and see what the import preview shows. It may help in debugging then combining the files from a folder.

kylon_19's avatar
kylon_19
Frequent Visitor
6 years ago

Hi edhans,

 

Apologies for the confusion, I meant that the values in the problem columns are either a 0 or a 1 (I'll be sure to be more clear on this in the future).

 

Your recommendation for debugging worked. It turned out the sample file was in a weird format compared to the rest of the files and was causing the system to not recognize the values. 

 

Thanks!

edhans's avatar
edhans
Community Champion
6 years ago

Great! Glad you found the issue.