Table of Contents

Power BI Dataset User Guide

For further information refer to: Official Power BI Documentation


x. Support & Feedback

  • Questions or requests? Submit a ticket via JIRA.

Table Glossary

Dimension Tables

Underlying Table Source in D365 (Page) Source in D365 (Table)
Dim_AdditiveFormulaProduct Product information management > Products EcoResConfiguration
Dim_Batch Warehouse management > Setup > Stock > Batch InventBatch
Dim_CallOff Purchase Ledger > Purchase contract call-offs > Purchase contract call-offs FdyPurchCallOffTable
Dim_Carrier Transportation management > Setup > Carriers > Carrier's fleets TMSCarrier
Dim_CarrierService Transportation management > Setup > Carriers > Shipping carriers TMSCarrierService
Dim_Company Organisation administration > Organisations > Legal entities DataArea
Dim_ContractCoverageType N/A GlobalOptionsetMetadata
Dim_ContractPool Feed Dynamics > Setup > Contract pools FdyContractPool
Dim_Currency General Ledger > Currencies > Currencies Currency
Dim_Customer Sales and Marketing > Customers > All customers CustTable
Dim_CustomerGroup Sales Ledger > Setup > Customer groups CustGroup
Dim_CustomerSalesPool TODO FdyCustomerSalesPoolTable
Dim_Date Cost Accounting > Ledger setup > Financial Calendars FiscalCalendar, FiscalCalendarYear, FiscalCalendarPeriod
Dim_DefaultLedgerDimension ? General ledger > Chart of accounts > Dimensions > Financial Dimensions DimensionAttributeValueSet
Dim_DeliveryMode Sales and marketing > Setup > Distribution > Modes of delivery DlvMode
Dim_DowntimeReason Production control > Setup > Production shop floor application > Resource downtime reasons FdyProdAppResourceDowntimeReasonTable
Dim_Driver Transportation management > Setup > Carriers > Drivers AxpTransDriverTable
Dim_ForecastModel Project management and accounting > Setup > Demand forecasting > Forecast models ForecastModel
Dim_GrainPassport TODO FdyGrainVarietyTable, AxpTransWeighticketOrder
Dim_InventoryReceiptCostType TODO FdyInventReceiptCostTypeTable
Dim_InventoryTransactionType N/A GlobalOptionsetMetadata
Dim_Invoice Sales ledger > Enquiries and reports > Invoices > Invoice journal CustInvoiceJour, CustInvoiceTrans
Dim_Item Product information management > Feed products > Product Management InventTable, FdyProductTableItems, FdyProductTable
Dim_Lab Lab information management > Setup > Labs AxpLabTable
Dim_LabAttribute Lab information management > Specifications > Attributes AxpLabAttributeTable
Dim_LabEquipment Lab information management > Equipment > All equipment AxpLabEquipmentTable
Dim_LabSample Lab information management > Samples > Samples AxpLabSampleTable, AxpLabSampleOrigin
Dim_LabSpecificationVersion Lab information management > Specifications > Specifications AxpLabSpecificationVersion
Dim_LabTestLine Lab information management > Test orders > All test orders > Select Test Order AxpLabTestLine, AxpLabTestTable, AxpLabProcessTable, AxpLabMethodTable
Dim_LedgerDimension ? General ledger > Chart of accounts > Dimensions > Financial Dimensions DimensionAttributeValueCombination
Dim_Load Transportation management > Planning > Loads > All loads WHSLoadTable
Dim_Location Warehouse management > Setup > Warehouse > Warehouses InventLocation
Dim_PaymentMode Purchase ledger > Payment setup > Methods of payment, Sales Ledger > Payments setup > Methods of payment CustPaymModeTable
Dim_PaymentTerms Purchase ledger > Payment setup > Terms of payment, Sales Ledger > Payments setup > Terms of payment PaymTerm
Dim_Person Human resources > Workers > Workers HcmWorker, DirPartyTable
Dim_Production Production control > Works orders > All works orders ProdTable, ProdGroup
Dim_PurchaseContractLine Purchase ledger > Purchase contracts > Purchase contracts > Select Purchase Contract FdyPurchContractLine, FdyPurchContractTable
Dim_PurchaseContractReservation Purchase ledger > Purchase contracts > Reservations FdyPurchContractReservation, FdyPurchContractLine
Dim_PurchaseInvoice TODO VendInvoiceJour, VendInvoiceTrans
Dim_PurchaseOrder Purchase ledger > Purchase orders > All purchase orders PurchTable
Dim_PurchaseOrderLine Purchase ledger > Purchase orders > All purchase orders > Select Purchase Order PurchLine, PurchTable
Dim_PurchasePool Prodcurement and sourcing > Setup > Purchase orders > Purchase pools PurchPool
Dim_Reason Organisation administration > Setup > Financial reasons ReasonTable
Dim_Resource Organisation administration > Resources > Resources WrkCtrTable
Dim_SalesContractLine Sales ledger > Contracts > All sales contracts > Select Sales Contract FdySalesContractLine, FdySalesContractTable
Dim_SalesContractRequirement Sales ledger > Contracts > All sales contracts > Contract requirements > View FdySalesContractRequirementTrans
Dim_SalesGroup Sales and marketing > Commissions > Sales groups CommissionSalesGroup
Dim_SalesOrderLine Sales ledger > Orders > All sales orders > Select Sales Order SalesLine, SalesTable
Dim_SalesPool Sales and marketing > Setup > Sales orders > Order pools SalesPool
Dim_Shipment Transportation management > Planning > Shipments > All shipments WHSShipmentTable
Dim_Shift N/A N/A
Dim_Site Stock management > Setup > Warehouse > Sites InventSite
Dim_SiteLocation Weighbridge > Setup > Site locations > All site locations FdyWbSiteLocationTable
Dim_Tractor Transportation management > Vehicles > Vehicles AxpTransTractorTable
Dim_Trailer Transportation management > Vehicles > Trailers AxpTransTrailerTable
Dim_TransferOrderLine TODO InventTransferTable
Dim_Unit Organisation administration > Setup > Units UnitOfMeasure
Dim_Vendor Purchase Ledger > Suppliers > All suppliers VendTable
Dim_VendorGroup Purchase Ledger > Suppliers > Supplier groups VendGroup
Dim_Weighbridge Weighbridge > Setup > Weighbridges > Weighbridges FdyWeighbridgeTable

Fact Tables

Underlying Table Source in D365 (Page) Source in D365 (Table)
Fact_Cost TODO FdyCustInvoiceTransCostTable
Fact_Deliveries TODO CustPackingSlipTrans
Fact_ErrorQuantity TODO ProdJournalProd
Fact_ForecastSales Master planning > Forecasting > Manual forecast entry > Demand forecast lines ForecastSales
Fact_GeneralJournalAccountEntry General Ledger > Journal entries > General journals > Lines GeneralJournalAccountEntry
Fact_InventTransfer TODO InventTransferJourLine
Fact_InventoryReceiptCosts TODO FdyInventReceiptCostTable
Fact_InventoryTransactions TODO InventTransOrigin, InventTrans
Fact_LabSpecificationLine Lab information management > Specifications > Specifications > Specification lines AxpLabSpecificationLine
Fact_LabTestResult Lab information management > Test orders > Results History AxpLabTestResultTrans
Fact_LoadCost TODO FdyWHSCostsTable
Fact_LoadLine Transportation management > Planning > Loads > All loads > Select Load WHSLoadLine
Fact_Payables TODO VendTrans, VendSettlement
Fact_Production Production control > Works orders > All works orders ProdTable
Fact_ProductionConsumption TODO InventTransOrigin, InventTrans
Fact_ProductionOutput TODO InventTransOrigin, InventTrans
Fact_PurchaseContractReservations TODO FdyPurchContractReservation
Fact_PurchaseContractReservationsByPurchaseContractLine TODO FdyPurchContractLine
Fact_PurchaseContractReservationsBySalesContractRequirement TODO FdySalesContractRequirementTrans, FdyPurchContractReservation
Fact_PurchaseContractTransactions TODO FdyPurchContractTrans
Fact_PurchaseInvoice TODO VendInvoiceTrans, VendInvoiceJour
Fact_PurchaseOrder Purchase ledger > Purchase orders > All purchase orders PurchLine
Fact_Receivables TODO CustTrans, CustSettlement
Fact_ResourceDowntime TODO FdyProdAppResourceDowntimeTable
Fact_SalesContractRequirements Sales Ledger > Contracts > All Sales contracts > Contract requirements > View FdySalesContractRequirementTrans
Fact_SalesContractTransactions Sales Ledger > Contracts > All Sales contracts > References > Transactions FdySalesContractTrans
Fact_SalesInvoice Sales Ledger > Enquiries and reports > Invoices > Invoice Journal CustInvoiceJour, CustInvoiceTrans
Fact_SalesOrder Sales ledger > Sales orders > All sales orders SalesLine, InventTransOrigin, InventTrans
Fact_StockValue TODO InventValueReportTmpLine
Fact_WeighCycle Transportation management > Weightickets > All weightickets FdyWeighCycleTable