Connect to Microsoft Dynamics AX content pack with Power BI

Is this page helpful?

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.

Connect to the Microsoft Dynamics AX Retail Channel Performance, the Financial Performance or the Cost Management content pack for Power BI.

How to connect

  1. Select Get Data at the bottom of the left navigation pane.

  2. In the Services box, select Get.

  3. Select one of the Dynamics AX content packs and choose Get.

  4. Specify the URL of your Dynamics AX 7 environment. See details on finding those parameters below.

  5. For Authentication Method, select oAuth2 > Sign In. When prompted, enter your Dynamics AX credentials.

  6. 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.

What now?

What's included

The content pack uses the Dynamics AX 7 OData feed to import data related to Retail Channel, Financial, and Cost Management performance respectively.

System requirements

This content pack requires a Dynamics AX 7 environment URL and the user should have access to the OData feed.

Finding parameters

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.

Next steps

Get started in Power BI

Get data in Power BI