Hello,
I'm having an issue with Microsoft's pre-built Sales Power BI App and Local Currencies. The LCY is CAD, but Power BI is picking up the USD amount from the sales invoice. The Posted Sales Invoice line is in USD, but the G/L entry is in CAD as it should be. How can I get Power BI to actually pick up the correct CAD LCY amount? Is this a Power BI issue or a BC Setup issue? Please see the attached screenshots.