"Date/Time format changes when exporting from Power BI Service to Excel – How to fix?"

Hi lucaspisso ,

This is a common issue when exporting from Power BI Service to Excel, as the format of Date/Time fields can change due to differences in how Power BI renders visuals versus how Excel interprets raw data. In Power BI, formatting is often visual-layer based, but when exporting, Excel receives the underlying data without those visual formats applied.

To ensure consistency, you can create a new calculated column or measure that explicitly formats the Date/Time as text using DAX, like this:

FormattedDate = FORMAT([YourDateField], "yyyy-mm-dd hh:mm:ss")

Alternatively, ensure the column’s data type in Power BI is set to Date/Time (not just Date or Text), and apply a consistent format under Column Tools. However, this might still not carry over visually on export, so using FORMAT() as text is your most reliable option.