Forum Discussion

Brent_Hel700's avatar
Brent_Hel700
Frequent Visitor
3 years ago

Paginated Report Builder calculating measures differently between Power BI Service and Excel Export

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.

 

1 Reply

  • Jon-Heide's avatar
    Jon-Heide
    Icon for Microsoft Employee rankMicrosoft Employee

    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.