Forum Discussion
Anonymous
5 years agoNot applicable
Datedatatype conversations
Hi Team, i have event start date and event end date columns coming from that was working fine in sql but power bi it's throwing error. Please find the below screen shot for sql and power bi and help me to resolve this issue.
Hi Anonymous
You should try to use Power Query transformation to data type using locale. In your case, Power BI tries to convert data using US date format, where month comes first (MM/DD/YYYY).
Eugene
1 Reply
- Evgeniy_OFrequent Visitor
Hi Anonymous
You should try to use Power Query transformation to data type using locale. In your case, Power BI tries to convert data using US date format, where month comes first (MM/DD/YYYY).
Eugene