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!

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi  Anonymous ,

     

    Glad to hear that ! Could you pls mark the reply as answered to close it?

     

    Much appreciated.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!