Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi,
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!
Thanks and regards
Guido
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.