Reporting - Web Service Query Combining Multiple Tenants

(0) Share

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 (2)

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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
Verified answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

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

thinkaboutit.be/.../

Was this reply helpful? Yes No