Forum Discussion
Date/Time data tipe values in error
Hi, I'm building a report where I need to filter my visuals by the date and time a sales document was created on. I extract this information exactly the same everyday and upload it to powerbi wi...
Hi Anonymous ,
According to this similar thread, it seems like PowerBI Service expect date mm/dd/yyyy format until there is a way to change locale in powerbi service.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I changed the date format in my excel source to mm/dd/yyyy and did the same in Power BI and still gotthe same error in Power Query. Then tried to get this field by using the concatenate function in the Data tab and got the same error.
Thank you