Power BI Gold Reports

Power BI Gold takes all the hard work out of implementing Power BI for reporting from a Microsoft Dynamics NAV database. It consists of individual report packs, each relating to a specific module in NAV with its own unique set of standard visuals and datasets.

In this installment post I’m going to explore the Power BI Gold for Purchasing Report pack in more detail.

The Item Purchases Report categorises purchasing into three key areas: outstanding purchase orders, received not invoiced purchase orders, and purchase value entries (posted).

Within this, you can further categorise reporting by date (e.g. month, year, quarter, previous year) as well as by Item, Location, Vendor, Purchaser and NAV Dimensions 1 through 8.

Power BI Gold for Purchasing comes with these standard measures used throughout the report that can be interacted with and filtered down by any of the areas mentioned above.

As with all Power BI Gold report packs we’ve built a standard set of visuals to get you started. These include, Purchases by Item, Purchases by Purchaser, and Purchases by Vendor pages, for example. You also have the ability to drill down on these key reporting areas to view more detailed information such as what item was purchased, the quantity for that specific transaction, and the date it was purchased.

Users can also use the dataset within the report to generate their own visuals. This gives them the ability to easily interact with their data.

If you’d like to experience how Power BI can improve the way you consume data from NAV,  we can help you.

Written By Nathan Gorga

Nathan initially joined Fenwick in February of 2017 for a six month Industry Based Learning (IBL) placement during his Bachelor of IT degree at Swinburne University. He then continued working for us part-time while he completed his degree. Once he graduated Nathan became a full-time Fenwick consultant. He has a particular interest in how data can be manipulated in a way to best improve business decision making.


We're here to help!

Call us

03 9695 3333

Or, leave us a message