Forum Discussion

rbalza's avatar
rbalza
Helper III
5 years ago
Solved

Dates Data Type on Tasks Planner - Power Query

Hi PBI Friends,   Been working on MS Planner data and when I am exporting it on excel file, the dates (data type) where exported as a Text. How can maintain it as a date data type when exported as ...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi rbalza 

     

    You don't need to change the data type in Excel. Instead, in Power Query Editor, remove your current Change Type step first. Then right click on the Date column and select Change Type > Using Locale... In the Change Type window, select Date for Data Type, select a locale which has the same date format as your original Date column in Excel. This will change the type into Date correctly. See a similar thread: error date column

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi rbalza 

 

You don't need to change the data type in Excel. Instead, in Power Query Editor, remove your current Change Type step first. Then right click on the Date column and select Change Type > Using Locale... In the Change Type window, select Date for Data Type, select a locale which has the same date format as your original Date column in Excel. This will change the type into Date correctly. See a similar thread: error date column

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.