Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Cobra77
Post Patron
Post Patron

Export Data with current layout option : "Error" Date Format in Excel

Hi, 

When the data in the table is exported to Excel using the Data with current layout option , the date format

the format of the date coming from an indicator in ShortDate format is no longer the same format in excel :

 

Cobra77_0-1647014626080.png

The result : ( english format ? )

Cobra77_3-1647015577469.png

 

 

With Summarized and Underlying Data its ok :

Cobra77_2-1647015484475.png

 

1) on the dataset ( SSAS Tabular 2016 ) :

Cobra77_4-1647015669169.png

2) Properties measure :

Cobra77_6-1647015899693.png

3) My regional settings on my PC are in French


4) on the server : 

Cobra77_5-1647015804250.png

 

would this be due to this?

Thanks for your helps

 

 

1 REPLY 1
lbendlin
Super User
Super User

This here is the questions and answers forum - for issues and bugs you may want to head over to https://issues.powerbi.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors