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 ...
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!

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous very hard to tell, we can have a quick call if you want me to take a look, send me an email that is in my signature. I'm around for another 30 min or so.

 

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.⚡

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k  could the reason why the CSV files aren't loading in because of the recent update to power bi desktop?

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous I don;t think so, it is something with the transformation, hard to tell without looking at it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       parry2k  what would you have to look at to possibly find a fix?  Also could it be that location 2 isn't in power bi?

       

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous As mentioned previously I'm out of ideas until I get to see it, if you want, send me an email and we can schedule a time to take a look.