Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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_O's avatar
    Evgeniy_O
    Frequent 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