Forum Discussion
Export Data - Data with current layout not keeping correct date format
Hello, I have a report in Power BI service with some date fields in it. As the language of my browser is Dutch, the correct date format 'dd/mm/yyyy' is shown in the report. Exporting t...
In case anyone on this thread has not solved, I found the solution on another thread. When authoring in PBI desktop, do not use the formats prefixed by an asterisk as the service will convert to the system / browser date format. Although this isn't a problem viewing your report when you have set your format settings correctly in your browser, PBI service doesn't take this into account when exporting to Excel (at least not with the newer 'current layout' option)
Use the non asterisk version and your export to Excel woes should be gone.