Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Have encountered a scenario where the export ("Data with Current Layout") to Excel file mirrors what is visible in the Power BI service online.
However, if a 'sum' is done on the column, the value calculated within Excel does not match what is in the Power BI visual.
Row limit not exceeded.
Hi @ryanwright
I agree with what @d_gosbell. But this problem generally doesn't occur. Can you tell us about your specific situation and what visual and measure you used? so that we can analyze it.
There are many considerations and limitations to refer to:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Best Regards,
Community Support Team _ Janey
There are a number of possibly explanations for this.
One possibly reason is that the column you are looking at is doing a more complex calculation than a simple sum. If it is a measure that is doing a distinct count or a percentage the total will most likely be different to a sum of the values in the rows.
Another possible explanation is that this could be a rounding issue. If you had 2 rows with values of 1.5 and 2.5 but had set the display to not show any decimal places these would round up to 2 and 3, but the grand total would be shown as 4, not 5 since it would be based on the raw data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |