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
You can definitely retrieve and combine sales data from multiple legal entities in D365FO using OData, but it requires careful setup. Ensure that entity data is properly exposed and that cross-company data access is enabled. Also, handling security roles correctly is crucial to accessing multiple entities. You might also find Arrest insights Alabama useful for exploring structured data approaches. If performance becomes an issue, consider aggregating data in a staging table before pulling it into Power BI.