web

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

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Reporting - Web Servic...

Small and medium business | Business Central, N...

Answered

Reporting - Web Service Query Combining Multiple Tenants

(0) Share

Report

Report

Posted on by Anita75

1,165

HI,

I'm trying to find out the best way combine data from multiple tenants (companies in BC) and not sure if a query can be published as web service that pulls data from multiple companies or maybe combining data in Power BI is better (if different data sources can be linked to same report)

Thanks

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

For reports that mix data between tenants, I recommend to use external tools like Power BI or others.

Queries can be published as ws and if you call them by passing the right url, you can retrieve data from different companies or different tenants, but this must be done externally.

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,682 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here's an example on how to do this in Power BI:

thinkaboutit.be/.../

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,964 Super User 2026 Season 1

#2

Dhiren Nagar 1,086 Super User 2026 Season 1

#3

YUN ZHU 1,039 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans