Using Power BI with NAV-X Commission Management
We have created data feeds for the relevant data in NAV-X Commission Management so that you can create Power BI reports easily using your data directly from Business Central. We have added some information on how to get started with Power BI in the bottom at See Also. The instructions are generic to enable Business Central for Power BI.
Important
The instructions from Microsoft describe how to connect Business Central SaaS to Power BI. On premise installations have to enable OData services and allow access from the internet to the OData endpoint for Business Central.
You will find our NAV-X Commission Management data as part of your Business Central data for Power BI. You have the following additional data available that can be pulled into your Power BI reports.
| Power BI Customer Commission | Commission data by customer |
| Power BI Sales Invoices | List of sales invoices and individual lines. This can be used together with commission data to create reports |
| Power BI Salesperson Commission | Commission data by salesperson. It also includes customer and customer ledger entry details |
| Power BI Service Invoices | List of service invoices and lines. This can be used together with commission data to create reports |