Power BI and Dynamics AX: Part 5: PowerBI.com and On Premise Data (Preview)

  This is the final part of the Power BI and Dynamics AX blog series for now, the earlier posts focused on the current functionality available within Power BI for Office 365. This blog post is going to talk about new functionality, that at time of writing, is only available in preview. This the topic…

0

Power BI and Dynamics AX: Part 4: Data Refresh and Q&A

  This is part four, continuing from Part 3: Create and Publish Visualisations. This post will focus on Data Refresh within PowerBI and how to get started with Power Q&A. At this point in the process we have extracted data from Dynamics AX using Power Query, transformed our data, created a visualisation using PowerView and…

0

Power BI and Dynamics AX: Part 3: Create and Publish Visualisations

  This is Part Three, continuing from Part 2: Extract and Transform. This post will focus on the creation and publishing of visualisations. At this point in the process we have a workbook, with a transformed data model – we are ready to create a visualisation to present our data. This post isn’t meant to…

0

Power BI and Dynamics AX: Part 2: Extract and Transform

  This is part two continuing from Power BI and Dynamics AX: Part 1: Introduction. This post will focus on the steps involved in extracting data from Dynamics AX into PowerQuery and transforming that data ready to be exposed in your visualisations, or used in PowerQ&A. Extracting Data via OData The first few steps of…

2

Power BI and Dynamics AX: Part 1: Introduction

The recent updates to Power BI on Office 365 have opened up a huge amount of potential for leveraging Power BI functionality for analytics on Dynamics AX data. This first post is going to focus on the high level architecture and the various components involved. The next few posts in the series are going to…

1