Hello, When I Export Data from a table visual in Power BI Desktop, the numbers I see as a Total in the Table Visual do not match the numbers I see in Excel when I perform a SUM on the same column of data. I have a Sales Amt - YTD measure that is formatted as a whole number in our Tabular model. The total for this column in the example I am using is 155,895 in Power BI Desktop. When I export the data and open in Excel, the total for this column is 155,903. There is obvioulsy some rounding going on during the export process. What is causing Power BI Desktop to recognize the decimal percision of the Sales Amt - YTD measure that is formatted as a Whole Number in Tabular? Why does the Export Data feature round the number when Power BI Desktop does not? When I change the Data Format of the measure to be Currency or Decimal with two decimal places the numbers are consistent and percise in both Power BI Desktop and Excel. If I change the Currency or Decimal measures to have 0 Decimals in the Tabular model, I get the same result as decribed above, where it is totaling to 155, 895 in Power BI Desktop but the exported data is totaling to 155, 903. I would expect these totals to tie in Power BI Desktop and in Excel for the exported data. Please explain the inconsistencies. Thanks, David
... View more