web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

CDS (Common Data Service) vs Web Service

(0) ShareShare
ReportReport
Posted on by

Let's imagine that I want to consult the Customer table, and a custom table in Business Central, from Power BI.

Until now we published the related WS and connected from BI.

With CDS, would we improve something? I understand that we would have to create entities, fill the data with Power Automate etc.

Regards.

  • Suggested answer
    THE Italian Profile Picture
    Microsoft Employee on at

    Go for WS. 

    CDS is used for integrations where typically you need to have have different mapping rules between one or another system.

    In you example you just need a data pump and WS guarantee more flexibility and less software substrates.

    I would use CDS e.g. if you need to extend the existing Dynamics 365 integration. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 554 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 360 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 201 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans