Forum Discussion

astano05's avatar
astano05
Icon for Helper III rankHelper III
5 years ago
Solved

Export Data Does not Retain Formatting

I have a table in Power BI, but when exported to xlsx, it does not retain the column formatting (currency, percentages, decimal places) so it requires additional formatting in excel. When exported as...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    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.