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.
I have created financial statements in Power BI Report Builder and am using Subreports to consoldate them to a single report builder report for Excel export. The problem is that when I view the consolidated report on Power BI service, the measure calculates different results than when I immediately export them to Excel. This issue is causing incorrect financials to be sent to clients.
We literally analyze the report in Power BI service, then simply click "Export to Excel" for that report and it is providing different (and incorrect) financial measures.
Below are some screenshots of this phenomena. It doesn't quite make sense that this is even possible:
Figure 1: View of Net Income Measure in Power BI Service
Figure 2: Next I validate the Net Income Measure in Power BI Service (33,248) and click Export -> Microsoft Excel
Figure 3: Microsoft Excel calculates the Net Income measure differently on Excel Export (25,261)
It goes without saying that critical financial information is being changed by the Microsoft Power BI Service platform and this issue needs to be addressed immediately.
Hi Brent - suggest contacting microsoft support to help walk through your issue. There could be various reasons based on how the dataset, reports, parameters or subreports are used.
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.