D365FO - Get Data From Many Legal Entities

[djiwu]

Hi,

I'd like to get the data from many Legal entitiy using OData, is it possible?

Let's say I want to combine  sales in multiple legal entities to get my sales for each entities and compare them.

And also I have many other requirement that need me to get the data from multiple legal entities.

I'm using PowerBI Desktop, Get data using OData & Sandbox environment D365FO.

Anyone have experienced this before? Could you share with me how to handle this scenario?

I've browsed around and not found any solution that works with current version of D365FO and PowerBI.

Thanks in advanced.

[judspud · Accepted solution]

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

[Umerinn]

Hi George,

I have also changed the url as you mentioned but I am not getting the data from both of my entities. What should I do?

Regards,

Umer

[sheik121]

Can u explain in detail with navigation if possible where to add that string.

thanks in advance.

[djiwu]

Hi George,

Thanks, it works!