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.

Access data with Excel

The following 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   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   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   Use Power View and Power Map to create interactive charts and graphs that help you explore and present your data visually in Excel.

Collaborate in Office 365

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

  • Share   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.
  • Ask questions   Type your questions into the Q&A speech bubble for immediate answers in the form of interactive charts and graphs.
  • Access anywhere   Access the latest reports posted to your Power BI site from an app on your mobile device.

Use Power BI for Office 365 with Dynamics AX

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.

 

For details, see Microsoft Dynamics AX integration with Power BI for Office 365.