web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... MS Business Central Da...

Customer experience | Sales, Customer Insights,...

Suggested Answer

MS Business Central Data Model

(0) Share

Report

Report

Posted on by DataHero

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Leco Lv Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 107 Super User 2026 Season 1

#2

#3

Muhammad Shahzad Sh... 69 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans