Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Microsoft Dynamics AX (7) Power BI financial pack shows only zeros

We have a situation when Microsoft Dynamics AX Power BI financial pack on all the reports shows zero. The account structure, fiscal year and all other data was imported correctly but the transactions were always showing zero.

This due to configuration in Dynamics AX you need setup value for System currency and exchange rate type to get the values correctly in PowerBI:

scr1

After you change it you need to refresh the data source in PowerBI.com