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.

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

Did you test with a live database connection? That seems to be the difference for me at least. With other non-live sources, the formatting is retained for me, but with the live connection it is not. I'm using Excel 365 version 2103.

 

Exporting as a CSV and converting is a workaround, but I'm concerned about the end-user adoption - and if they add any charts or totals they wont be saved, so I would prefer a straight forward solution if it exists. 

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
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.