Skip to main content


Showing posts from July, 2015

Walk through of PowerBI

On 24th of July Microsoft announced the release of PowerBI . With that comes a lot of new features and I have to say it is a lot simpler to use. In this post I will walk you through what I did to get my first report done in 10 minutes. Download PowerBI Desktop and install it. (No need to show installation steps as it was super simple to follow the wizard). Once that is done, I signed up on the website with my work email (we are already on Office365). First thing to do is give it a data source. In my case I chose OData to get AX data. You will get the list of data sets available in AX. I selected one of them and manipulated some of the columns. Usual thing you would do is rename the columns, maybe do filtering or grouping. You may add additional data to link to. Then next thing you do is click on the Load (Close & Load button). Once it is loaded, you can start creating the report. I did a basic pie chart. You then can click on th

Named user license count report [AX 2012 R3 CU9]

It looks like there are some updates to the license count reports in CU9. First you will notice a new report called “ Named User License Counts History ”. Lets go through both. 1. Named User License Counts This was a report that existed since the initial release of AX2012 but some additions have been made. Now you have the users (which was released sometime in R2) and in R3 CU9 we have another addition. We now see the users role, not just the license type. 2. Named User License Counts History This report takes a from and to date. Then displays a summary type report of what the actual is and what you are licensed for.