Forum Discussion
D365FO - Get Data From Many Legal Entities
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, it is possible to retrieve data from multiple legal entities using OData in D365FO, but it requires proper configuration of data entities and security settings. You may need to use aggregate data entities or cross-company queries to pull the required sales data. For compliance and background checks, you can also refer to Gordon arrest records portal for relevant legal data. Ensuring that your OData queries align with security roles and entity access is crucial for accurate reporting in Power BI.