Power bi total column totals not adding up in excel extract

[Sunila]

Hi, 

We are currently dealing with a situation where I have published the report in Power BI services. However, when users export the data to Excel, the sum of totals in Excel doesn't align with the reported values in Power BI. Specifically, the table export sum in Excel doesn't match the sum of the columns in Power BI, strangely for only a few columns. Highly appreciate any assitance on this issue.

[lbendlin]

Please provide more details. Are you using Analyze in Excel, or export?  If export, which variation? Are these columns or measures?

[Sona2023]

Export to Excel. These are all measures.

[lbendlin]

Which export to Excel? Legacy, or with live connection?

[Sona2023]

Report is having an import mode and ingesting the data from D365 F&0. All the measures are  dynamically calculating the amount based on the selected start date and end date. 

[lbendlin]

I am talking about this option

[Sona2023]

Oh, we are using Data with current layout, the very first option 🙂

[lbendlin · Accepted solution]

that will convert measures into static values. I'd recommend you try one of the other options.