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's possible to retrieve data from multiple legal entities using OData in D365FO, but it requires proper entity setup and filtering. You may need to use cross-company queries and ensure security policies allow access to multiple entities. Additionally, data integration strategies vary based on reporting needs. For related legal records, you can check Oklahoma Arrest Reports for verified public data insights. Have you tried using composite data models in Power BI to manage entity-specific datasets?