Forum Discussion
Solved
D365FO - Get Data From Many Legal Entities
Hi, I'd like to get the data from many Legal entitiy using OData, is it possible? Let's say I want to combine sales in multiple legal entities to get my sales for each entities and compare them...
Hi djiwu
I did this recently when producing multi company reports.
When enetering your odata connection to the entity add '?cross-company=true' at the end of the odata string
https://xxxxxxxxxx.dynamics.com/data/Customers?cross-company=true"
Hope this helps
Thanks,
George
Yes, you can retrieve data from multiple legal entities in D365FO using OData, but it requires proper entity configurations and security permissions. You might need to use aggregate data entities or data management framework for better performance. Also, consider Search Engine Marketing to optimize your online presence while working with Power BI reports. Ensure you have the correct legal entity context set when querying OData to avoid access issues.