Forum Discussion
Preserving Date format without 12:00:00 AM
Hi, I have large table that I need to export out of Desktop into csv for some users. Even though I used Power Query to change everything to a type of date, when I go to export this into CSV I get t...
Hi Anonymous
You can use the Format function to enforce a specific format on the date column.Column = FORMAT('Table'[Date],"mm/dd/yyyy")Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
samratpbi
Super User
Super UserHi,
I think you are exporting from Power BI desktop. Can you please change the format to date and export from Service and see if the issue persists?
if this helps to resolve your problem, then mark it as solution, thanks
Thanks. Unfortunately the client is very new to Power BI and I don't have Service or Gatewawys set up for them. Is there a way to do in Desktop?