Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Power Query import show many col as null

Not sure what is going on here.  I am importing the contents of a folder.  There are 4 files.  All are formatted the same, etc.  One file has many columns importing all as null, but other columns are correct.  The other 3 files all import correctly.  If I create a separate PBI file with just the one file it works as expected.  What am I missing here?

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Sam,

     

    I am on the latest version.  I figured it out.  The column headers were slightly different.  Some had spaces between words and the other had underscores.  I knew it would be someing simple.

     

    Thanks for the response.

    Brian

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Sam,

       

      I am on the latest version.  I figured it out.  The column headers were slightly different.  Some had spaces between words and the other had underscores.  I knew it would be someing simple.

       

      Thanks for the response.

      Brian