Skip to main content

Notifications

Dynamics 365 Community / Forums / Sales forum / MS Business Central Da...
Sales forum
Suggested answer

MS Business Central Data Model

Posted on by 5

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

Categories:
  • Suggested answer
    Leco Lv Profile Picture
    Leco Lv on at
    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

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,107 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,954 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans