Forum Discussion

davinci_cat's avatar
davinci_cat
Frequent Visitor
2 years ago

Percentages truncated on export

I have a problem trying to export data from Power BI into Excel where the original values are like 4.547132009% but all I get in Excell is 4.500000000% and this creates a problem where the column of ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi davinci_cat 
check below steps

The issue you're experiencing where the percentages are truncated when exporting data from Power BI to Excel is likely due to the formatting settings in Excel. By default, Excel may round the displayed percentages for simplicity. To work around this issue and ensure the exported percentages retain their precision, you can follow these steps:

Method 1: Format the Column in Excel

  1. After exporting your data to Excel, select the column with the percentages.

  2. Right-click on the selected column and choose "Format Cells."

  3. In the "Format Cells" dialog box, go to the "Number" tab.

  4. In the "Category" list on the left, select "Percentage."

  5. Adjust the number of decimal places to the desired precision (e.g., 9 decimal places).

  6. Click "OK" to apply the formatting.

This will display the percentages in Excel with the desired precision.

Method 2: Use Power Query to Export Data

  1. In Power BI, you can use Power Query to export the data to Excel while specifying the desired data type for the percentage column.

  2. Load your data into Power Query by clicking "Edit Queries" in Power BI.

  3. In Power Query, select the percentage column, and in the "Transform" tab, change the data type to "Decimal Number" with the desired number of decimal places.

  4. After making this change, close and apply the changes in Power Query.

  5. Now, when you export this data to Excel, it should maintain the desired precision for percentages.