Microsoft Dynamics AX integration with Power BI for Office 365 [AX 2012]

Updated: June 11, 2014

Applies To: Microsoft Dynamics AX 2012 R3

This article explains how to use the features and services that are included in Power BI for Office 365 to access, explore, and gain insight from your Microsoft Dynamics AX data.

Microsoft Power BI for Office 365 is a collection of features and services that, together, enable you to visualize data, share discoveries, and collaborate in new ways. Familiar tools including Excel and SharePoint form the foundation of Power BI. The value of Power BI is how its features and services work together, and how the insights are securely, yet interactively shared.

Power BI for Office 365

The features listed in the following table are part of the familiar Excel environment. These features enable you to access data and display that data in interactive charts, graphs, and maps. Some of these features have been available before, some are new, but each is now integrated into Excel and into Power BI online services.



Discover data

Power Query

Use Power Query to access data from public and corporate data sources. Power Query includes a new online search feature that helps you find public data on the Web.

Analyze data

Power Pivot

Use Power Pivot to create analytical models in the familiar Excel environment. You can mash-up data from multiple sources and analyze large amounts of data.

Visualize data

Power View

Use Power View to create interactive charts and graphs that help you explore and present your data visually in Excel.

Power Map

Use Power Map to explore and navigate data on a 3D map in Excel.

The features listed in the following table help you share data and reports with team members who are anywhere in the world.



Share data

Power BI sites

Create collaborative Power BI sites for your team to share and view reports. Larger workbook viewing is also supported so that users can view and interact with larger workbooks through the browser.

Query your data by asking questions

Power BI Q&A

Type your questions into the Q&A speech bubble for immediate answers in the form of interactive charts and graphs.

Access your data when you're on the go

Power BI app

Access the latest reports posted to your Power BI site from an app on your mobile device.

The following diagram shows how you can use the features of Power BI for Office 365 to access, explore, and gain insight from your Microsoft Dynamics AX data.

How AX 2012 R3 integrates with Power BI
  1. Plan

    The first step in this process is to determine what data to display on your reports. For example, you’ll want to consider the following questions:

    • What is the business problem you’re trying to solve?

    • What data can provide insight into this issue?

    After you’ve figured out what data you want to display on your reports, determine what data sources you’ll use to access that data. You can use the following types of Microsoft Dynamics AX data sources:

    • OData feeds

    • SQL Server Analysis Services cubes

    • List pages

    You may also want to mash-up your data with other sources for deeper analysis. For example, you may want to mash-up your Microsoft Dynamics AX data with data from the Web. If so, identify those data sources, as well.

  2. Build

    After you’ve figured out what data sources you’ll use, you can build your reports and analyze data. The following articles provide examples of how to do this:

  3. Share

    To share reports with others in your organization, see the following articles:

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).