Power BI Gold for Sales provides insight into your Business Central sales data. Data is exposed using the Item Sales Report which allows you to build your own sales reports in a drag and drop environment.

Out of the box capability with standard measures

Comes with 90+ pre-built standard measures ready for reporting, such as:

  • Sales Amount/Cost Amount
  • Quantity
  • Budget Sales Amount (and the amount variance to actual sales)
  • Gross Profit/Gross Profit Margin

All measures have their relevant Year to Date (YTD), Previous Year (PY) and PY YTD calculations to support year-on-year comparisons of your data.

Drill down on results from these sales measures to the transactional level.

Slice and dice

Instantly report on Invoiced Sales, Backorders and Shipped Not Invoiced Sales Orders. Item Budget Entries are also incorporated which allows you to report on Budget vs. Actual.

Filter and compare Item Sales by Customer, Item and Salesperson as well as filtering by Business Central Dimensions 1 through 8.

Power BI Gold Suite

The Power BI Gold Suite takes all the hard work out of implementing Power BI reporting. It seamlessly links Business Central data to Power BI out of the box.

With Power BI Gold you can build reports by any dimension in the Business Central. Measures are ready to go, and the data is already modelled for analysis; instant plug and play for business reporting.

Connector for Business Central

There’s two parts to our solution — the data connector and the Power BI Gold Sales reports. Make sure you download both to get the most out of Power BI Gold.

Knowledge Base Articles