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.
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.