Connect to Microsoft Dynamics AX content pack with Power BI
Microsoft Dynamics AX has three Power BI content packs targeted at different business users. The Financial Performance content pack, designed specifically for CFOs, provides access to insights about your organization’s financial performance. The Retail Channel Performance content pack is targeted for channel managers focuses on sales performance to predict trends and uncover insights by drawing directly from Retail & Commerce data. The Cost Management is designed for COOs and CFOs and provides details on operation performance.
How to connect
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select one of the Dynamics AX content packs and choose Get.
Specify the URL of your Dynamics AX 7 environment. See details on finding those parameters below.
For Authentication Method, select oAuth2 > Sign In. When prompted, enter your Dynamics AX credentials.
After approving, the import process will begin automatically. When complete, a new dashboard, report and model will appear in the Navigation Pane. Select the dashboard to view your imported data.
- Try asking a question in the Q&A box at the top of the dashboard
- Change the tiles in the dashboard.
- Select a tile to open the underlying report.
- While your dataset will be scheduled to refresh daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now
The content pack uses the Dynamics AX 7 OData feed to import data related to Retail Channel, Financial, and Cost Management performance respectively.
This content pack requires a Dynamics AX 7 environment URL and the user should have access to the OData feed.
The Dynamics AX 7 environment URL can be found in the browser when the user signs in. Just copy the URL of the root Dynamics AX environment into the Power BI dialog.
The data may take some time to load depending on the size of your instance. If you're seeing empty reports within Power BI, please confirm you have access to the OData tables required for the reports.