Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I get data from OData feed I am able to access data only for the legal entity which is selected as default starting company.
When I change the legal from user options in Dynamics 365 for Operations the data that the OData feed return changes according to the selected default entity.
Do you know how to query OData to return all legal entities or some another ways to fix that?
I would like to be able to get all entities.
Solved! Go to Solution.
The problem was solved by adding a company column to the data entity through Visual Studio.
Hi @Birdjo,
Based on my research, you can append the ?cross-company=true parameter at the end of the OData URL. See: How do I specific a non-default legal entity in an OData request?.
As this issue is more related to the Dynamics 365 for Operations side, I see you already post a thread in Dynamics forum, you can get better answer from Dynamics 365 for Operations experts.
Best Regards,
Qiuyun Yu
The problem was solved by adding a company column to the data entity through Visual Studio.
Adding "?cross-company=true" used to work. However, with the new [Implementation="2.0"] it no longer does. I have not yet been able to find a way to pull all or multiple legal entities when using [Implementation="2.0"]. Which is a shame as it otherwise would help speed up queries.
Using D365FO 7.1 (about to roll up to 7.3)
Hi, anyone know how to pull all or multiple legal entities in D365FO when using PowerBI desktop?
For example pull all Sales lines data from multiple legal entities.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |