Power BI Multiple Companies D365 F&O

Mahmoud HakimFinance & Operations2 years ago54 Views

Cross-company behavior

By default, OData returns only data that belongs to the user’s
default company. To see data from outside the user’s default company,
specify the ?cross-company=true query option. This option will return data from all companies that the user has access to.

Example: http://[baseURI\]/data/FleetCustomers?cross-company=true

To filter by a particular company that isn’t your default company, use the following syntax:

http://[baseURI\]/data/FleetCustomers?$filter=dataAreaId eq 'usrt'&cross-company=true

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata#cross-company-behavior

Original Post http://dynamics365ax2012.blogspot.com/2022/06/power-bi-multiple-companies-d365-f.html

Upvote0PointsDownvote

0 Votes: 0 Upvotes, 0 Downvotes (0 Points)