Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 an excel file? As you can see, when I used it as a my data source, dates were giving me an error. Thanks!
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.