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.
Go to Solution.
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
Hope this helps
View solution in original post
Can u explain in detail with navigation if possible where to add that string.
thanks in advance.
Thanks, it works!
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!