Reporting - Web Service Query Combining Multiple Tenants

(0) Share

Report

Posted on by Anita75

1,159

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

All responses (2)

Answers (1)

Verified answer

Steven Renders 5,500 Moderator on at

Like (0)

Report

RE: Reporting - Web Service Query Combining Multiple Tenants

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

thinkaboutit.be/.../
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Reporting - Web Service Query Combining Multiple Tenants

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.