Provides additional APIs to form a connection to your Navax Power BI Datawarehouse.
Current Version: 2.0.7.0as of Business Central 19.
Manual
Creation date: 2024/11/22 The current version of this manual can be found at:
☰ Contents
General
App Power BI Package The App Power BI Package creates an interface between the NAVAX Datawarehouse and BC with all its used tables (Sales, Production,...)...
Setup
App Setup The app is used as interface between Business Central and the NAVAX Datawarehouse...
Tasks
Working with the App
Appendix
Release Notes
Docs / NVXPBI Power BI Package / General General
The App Power BI Package creates an interface between the NAVAX Datawarehouse and BC with all its used tables (Sales, Production,...).
Docs / NVXPBI Power BI Package / Setup App Setup
The app is used as interface between Business Central and the NAVAX Datawarehouse.
Actions
Application set up
Following information are nessesary for the NAVAX Datawarehouse:
Tenant ID
Client ID
Secret ID
Customer IDs
This information must be send to the NAVAX Datawarehouse Consultant.
Docs / NVXPBI Power BI Package / Tasks Working with the App
Following services will be provided to the NAVAX Datawarehouse:
PBIaccScheduleLinesNVX
PBIaccScheduleNamesNVX
PBICalendarEntriesNVX
PBICapacityLedgerEntriesNVX
PBIcompanyInformationNVX
PBIcontactBusinessRelationsNVX
PBIcontactsNVX
PBIcountryRegionsNVX
PBIcurrencyExchangeRatesNVX
PBIcustLedgerEntriesNVX
PBIcustomersNVX
PBIdetailedCustLedgEntriesNVX
PBIdetailedVendorLedgEntriesNVX
PBIdimensionsNVX
PBIdimensionSetEntriesNVX
PBIdimensionValuesNVX
PBIgeneralLedgerSetupNVX
PBIgenProductPostingGroupsNVX
PBIgLAccountsNVX
PBIgLBudgetEntriesNVX
PBIgLBudgetNamesNVX
PBIgLEntriesNVX
PBIitemCategoriesNVX
PBIitemLedgerEntriesNVX
PBIitemsNVX
PBIjobLedgerEntriesNVX
PBIjobsNVX
PBIjobPlanningLinesNVX
PBIjobTasksNVX
PBIlocationsNVX
PBImachineCentersNVX
PBIprodOrderCapacityNeedsNVX
PBIprodOrderComponentsNVX
PBIprodOrderLinesNVX
PBIprodOrderRoutingLinesNVX
PBIproductionOrdersNVX
PBIpurchaseHeadersNVX
PBIpurchaseLineArchivesNVX
PBIpurchaseLinesNVX
PBIpurchCrMemoHdrsNVX
PBIpurchCrMemoLinesNVX
PBIpurchaseHeaderArchivesNVX
PBIpurchInvHeadersNVX
PBIpurchInvHeaderLinesNVX
PBIresourceCapacitiesNVX
PBIresourcesNVX
PBIreturnReasonsNVX
PBIreturnReceiptHeadersNVX
PBIreturnReceiptLinesNVX
PBIreturnShipmentHeadersNVX
PBIreturnShipmentLinesNVX
PBIroutingHeadersNVX
PBIroutingLinesNVX
PBIsalesCrMemoHeadersNVX
PBIsalesCrMemoLinesNVX
PBIsalesHeaderArchivesNVX
PBIsalesHeadersNVX
PBIsalesInvoiceHeadersNVX
PBIsalesInvoiceLinesNVX
PBIsalesLineArchivesNVX
PBIsalesLinesNVX
PBIsalespersonPurchasersNVX
PBISalesShipmentHeadersNVX
PBISalesShipmentLinesNVX
PBIsalutationsNVX
PBIscrapsNVX
PBIstopsNVX
PBIunitofMeasuresNVX
PBIuserSetupNVX
PBIvalueEntriesNVX
PBIvendorLedgerEntriesNVX
PBIvendorsNVX
PBIworkCenterGroupsNVX
PBIworkCentersNVX
PBIItemAttributesNVX
Docs / NVXPBI Power BI Package / Appendix Release Notes
Would you like to know what has changed in the extension? Below you'll find an overview of the new features and changes made in the updates.
Build-Overview in DevOps
NVXPBI 2.0.7.0
as of Business Central 19 2024/11/13
Modifications
PBIItemVariantsNVX added
NVXPBI 2.0.6.0
as of Business Central 19 2024/11/12
Modifications
PBIItemAttributesNVX added
NVXPBI 2.0.5.0
as of Business Central 19 2024/09/05
Modifications
Fields "Sales Amount (Expected)" und "Sales Amount (Actual)" added to PBIValueEntryNVX
NVXPBI 2.0.4.0
Modifications
Field "Global Dimension 1 Code" added to PBIsalespersonPurchasersNVX
NVXPBI 2.0.3.0
Modifications
Field "Document Date" added to PBIgLEntriesNVX
NVXPBI 2.0.2.0
Modifications
Field "Bill to Customer" added to Jobs
NVXPBI 2.0.1.0
Modifications
PBISalesShipmentHeaderNVX, PBISalesShipmentLineNVX, PBICalendarEntryNVX and PBICapacityLedgerEntryNVX added
