Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data is null

Hi everyone,

 

I have been loading csv files from ssms to power bi for the last couple of weeks and I haven't had an issue with it.  But when I ran it in ssms and loaded it into power bi today the data for this week 7/13/2020-7/14/2020 is not there.  When I run it in ssms all the data is there.  But when I look at the data in Power Query in Power BI all the columns but one say null.  I have been doing the same steps for the last couple of week so I am not sure why it would happen now. 

 Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi @parry2k ,

    Thanks for the suggestions on how to fix this. The CSV file is now working again. Not sure if it was me fixing the save columns with headers option in SSMS or it somehow fixed itself. Thanks again for the help!

11 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous weird, so you basically data for each week or your appending, can you share power query from the advanced editor, very hard to say what is going on.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      parry2k  here is the advanced editor query code

       

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous so you are reading the file from shrepoint, it is excel or CSV file? Do you see the data when you open the file directly? Did anything change compared to previous files?

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

        ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡