Forum Discussion
Data is null
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 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 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.⚡
parry2k it is a CSV file that I save from ssms. And yes I can see the data when I open the CSV file directly. The only thing that would've changed would be the location that the data is coming from (last couple of weeks location 1, this week location 2) but I have filters set to recignize the change in locations. And the data was there yesterday and now it's all null
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.⚡