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