Hi,
Im new to MSBC and wanted to ask for experiences with MSBC data in Power BI.
I feel, its very difficult to build a proper data model based on MSBC data.
Does somebody know what the central table is to build a sales report in PBI Desktop?
I cant find a table, containing enough columns to join Sales, SalesInvoiceLines and CreditMemos.
I thought it would be ItemLedgerEntries or ValueEntries, but I cant build a uniquie relationship to the other tables.
Thanks for any help!
Kind regards,
DataHero