Dynamics 365 OData Feed Returns One Company; Using Cross-Company Queries to Pull All Entities
A Power BI report built on Dynamics 365 finance and operations data showed only one legal entity, leaving most of the business out of the totals. The fix involves placing the cross-company=true option on the specific entity URL rather than the service root when using Implementation 2.0. Microsoft documents that by default OData returns only the user's default company, and the option returns data only from companies that user can access. Security still applies, so a service account lacking access to a legal entity will not see its data. For scheduled warehouse extracts, the guide recommends a Microsoft Entra app registration using client credentials and a dedicated service account.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.


Discussion (0)
Log in to join the discussion and vote.
Log in