MS Business Central Data Model

(0) Share

Report

Posted on by DataHero

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Leco Lv on at

Like (0)

Report

RE: MS Business Central Data Model

Hi partner,

Are you using Dynamics 365 BC? I think you need to move to dynamics 365 BC community.

Dynamics 365 Business Central Forum - Support & Help

Was this reply helpful? Yes No