Archive

PowerQuery

Using PowerQuery to Merge Datasets

December 8, 2013
Dynamics AX, PowerBI, PowerQuery
1 Comment

Up until now we have just been looking at the data from one data table within Dynamics AX. If you want to merge multiple tables together, then you don’t have to resort to using SQL statements, or building complicated queries, you can use PowerQuery to merge the data for you.

NOTE: This is part of the Using PowerBI to Analyze Dynamics AX Data blueprint series where we show how to use PowerView, PowerPivot & Power Map to analyze and visualize your data more effectively. If you want to see all of the other posts in this series, click
here.

Read More

Advertisement

Using PowerQuery to Clean up Your Data

December 8, 2013
Dynamics AX, PowerBI, PowerQuery
Leave a comment

Another of the PowerBI tools is PowerQuery. This is an incredibly useful tool, because it allows you to query and massage data directly within Excel. This is especially useful if you only want to report off some of the data, or if you want to pre-filter the data.

NOTE: This is part of the Using PowerBI to Analyze Dynamics AX Data blueprint series where we show how to use PowerView, PowerPivot & Power Map to analyze and visualize your data more effectively. If you want to see all of the other posts in this series, click
here.

Read More

Using PowerBI to Analyze Dynamics AX Data

November 27, 2013
Dynamics AX, Pivot Tables, PowerBI, PowerMap, PowerPivot, PowerQuery, PowerView
2 Comments

Everyone has used Pivot Tables within Excel at one point in time to create simple reports against Dynamics AX, and some of you may have also used Power Pivot to create more elaborate dashboards and charts.  Recently Microsoft extended out the query and reporting capabilities within Excel with the Power BI suite.  In addition to extending the Power Pivot capabilities, they also added three more tools called Power Query, Power View & Power Map, and that means that you have a whole new set of reporting options.

In this presentation we will show you how you can use all of the Power BI tools to analyze your Dynamics AX data.

Read More