Forum Discussion

rainerpowerbi's avatar
rainerpowerbi
Resolver I
4 years ago

Excelexport: Problem by date-fields

Hi, I think there is a bug in an option of the excel-export. Example: - I work in Germany with german date/time-settings The Report-column(as the SQL-Table) contains following field: (1. Fe...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, rainerpowerbi 

 

For all the visuals in PBI we need to choose “Summarized data” option instead of “Data with current layout”.

The summarized data will give you the formatted output with all the columns as is. However the data with current layout will export the underlined data and especially with the table visuals with date it mess up.

 

There are Export data options available, depending on your need you need to choose one of them. 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rainerpowerbi's avatar
rainerpowerbi
Resolver I
4 years ago

Hi Charlotte,

I tested your hint:

 

 

But...the bug is still there:
The shown value is still 1.2.22 instead of 1.2.22

WRONG:

 

The  new LAYOUT-EXPORT-OPTION is normally very good especially for MATRIX-Export.

I think the reason could be the German-settings in Excel but I think that a few weeks ago this problem did not exist.

Kind regards

Rainer