Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.