Export Data Does not Retain Formatting

Hi astano05 

I can only do test with Live Connection to SSAS or Power BI datasets. I cannot test the Live Connection to Azure Analysis Service with no luck. My test results is are following. I open the CSV and xlsx files with Excel 2016 and I've downloaded the Analyze in Excel updates from Power BI Service.

Here is the result:

1 Live Connection to SSAS

Export to CSV:

Export to xlsx:

2 Live Connection to Power BI datasets

Export to CSV:

Export to xlsx:

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.