Small and medium business | Business Central, N...

How should multi-currency reporting be handled in the Sales standard Power BI app?

(4) Share

Report

Posted on by BH-09040840-0

We are evaluating the standard Business Central Power BI app and have noticed what appears to be an inconsistency in currency handling.

Theapp retrieves data from tables including Value Entries, Sales InvoiceLines, and Sales Credit Memo Lines. Value Entries seem to use LCY amounts, while Sales Invoice Lines and Sales Credit Memo Lines appear to use amounts in the original document currency.

As a result, reports can display incorrect or misleading totals when transactions exist in multiple currencies, since amounts from different currencies are effectively mixed.
Could you clarify whether this is:
An intended design choice,
A known limitation,
Or a bug in the standard Power BI app?

What is the recommended approach for companies that sell in multiple currencies? Is there a supported way to consistently report in LCY (or alternatively allow users to switch reporting currency) without having to redesign the standard dataset?
At the moment, the app becomes difficult to use for multi-currency environments because the figures are not directly comparable.

Thank you!

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Teagen Boll 3,232 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I wouldn't change any setup or processes in BC in order to get the Sales Power BI app to do what you want. The Power BI apps for BC are just meant to be introductions to power bi and a good starting point. If you want anything specific you would have to build your own Power BI dashboards from scratch.

You can also try to submit product ideas to Microsoft to help manage the LCY and Foreign Currency concerns around the Power BI reports. They take ideas that end users can submit here: Ideas

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 17,730 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,
based on Microsoft’s own description of the Power BI Sales app measures, I would treat this mainly as a standard app/dataset limitation, not something I would rely on for serious multi-currency reporting out of the box. The Sales app uses a mix of sources such as Value Entries, Sales Invoice Lines, and Sales Credit Lines, and some measures are labelled LCY while still using fields like invoice/credit line Amount, which in BC can represent document currency depending on the source table. For companies selling in multiple currencies, the safer approach is to report financial totals from G/L Entry / Customer Ledger / Detailed Customer Ledger where LCY is consistent, or customize/copy the Power BI semantic model and explicitly convert document-currency sales lines to LCY using exchange rate / LCY fields where available. If you need a currency switcher, that would normally require a customized model; I do not think the standard template app gives a clean supported “switch reporting currency” option for this scenario.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 2,569 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'd call it a limitation more than a bug. The two sources just store amounts differently — value entries are always in LCY, that's how BC posts them, while the posted Sales Invoice and Cr. Memo lines keep the amount in the document currency. The standard app doesn't convert, so yes, mixing them gives you apples and oranges across currencies.

For multi-currency I'd lean on the value entry side for sales figures, since those are already LCY and comparable. If you need line-level detail, the posted headers carry Currency Code and Currency Factor, so you can divide by the factor in the model to bring lines to LCY — but that means touching the dataset, there's no toggle out of the box that I know.

Reporting in a second currency consistently usually means Additional Reporting Currency on the G/L side, not the Power BI app.

Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,814 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

If this helps:https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Multi-Currency-Reports-in-Power-BI/m-p/4719474

Was this reply helpful? Yes No