we are facing an issue when exporting data from PowerBi to Excel - either Online or via PowerBi Embedd. We have a simple table min PowerBi that makes a query to our SQL Server resulting in some columns that are datatype text and two columns that are dataype Date/Time.
Some of the Date/Time values are 01/01/1900 00:00:000. This is displayed correctly in PBI Desktop, Online and PBI Embedd.
When we export the data to .xlsx (online and embedd), these values change to 01/02/1900 00:00:000 - so it is not 1st of January and becomes the 2nd of January. This does NOT happen when we export to .csv!
I tried to set the locale for the Date/Time column but it doens't make any difference. We know for shure that this was not an issue a few month back, as our customers regulary export these data and if wans't an issue in the first quarter of 2022.
It seems that this is a new bahviour/bug within the xlsx export, but any help is appricated!
We have seen two similar icm 310616844 and 301493427 that were reported internally. Here is the feedback from the PG team.
“Export to Workbook is run on Power BI service machines, which OS may or may not have the same Date Time settings as expected on the client machine's OS.
In order to ensure Export consistency, user should choose a Date format without the asterisk.
As an alternate solution, suggested customer tochange their time format to (hh:nn:ss), and customer is getting the time exported in the same format in Excel after that. So, no issues with hh:nn:ss format (both in data with current lay out and Summarized data options, it works fine). ”