Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

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 percentages doesn't add up to 100% anymore. Are there any ways to work around this issue please?  TIA.


I have tried both showing data in Power BI as % of column total and I also created a measure to calculate the column total; the end result is the same.

Responsive Resident
Responsive Resident

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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors