Forum Discussion
"Date/Time format changes when exporting from Power BI Service to Excel – How to fix?"
Hi everyone,
I'm reaching out to ask for help regarding the export of Date/Time fields from Power BI Service to Excel.
When I export the data, the Date/Time values appear differently in Excel compared to how they are shown in Power BI. I've attached two screenshots for clarity:
The first shows how the Date/Time field appears in Power BI.
The second shows how the same field appears after exporting to Excel.
Could you please advise on what settings or transformations I need to apply so that the Date/Time values are displayed the same way in Excel as they are in Power BI?
Thanks a lot in advance for your support!
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.
3 Replies
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.
Hi lucaspisso ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank YouHi @lucaspisso ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You