Forum Discussion

Shanky_Jiraiya1's avatar
Shanky_Jiraiya1
New Member
2 years ago

Power BI Text to Date Conversion

Hi , I have Effective date column as General in Excel and it gets converted into Date when I change the data type to DATE. But when I import this file in PowerBI I am getting error as attached. How can I convert the value into date format as all the values are 30/06/2023 and no other values.

 

 

Need Help
Tips and Tricks

2 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    2 years ago

    Please don't share picture, share the code or your pbix file.

    Help us to help you 🙂

  • mickey64's avatar
    mickey64
    Icon for Super User rankSuper User
    2 years ago

    For your reference.

     

    Please click the icon below and select 'Date' of the pulldown menu.