You’re offline. This is a read only version of the page.
307
We have multiple companies we run through D365 F&O. We use Power BI to build reports from pulling the entities from OData. No-One seems to be able to tell us how to access all our companies. For example:
If I type in:
https://ongweoweh.operations.dynamics.com/data
I get my company A01 data
Now I also have B03, B13, A05 etc and we cannot figure out how to pull this in OData with the same concept. We have do do something like this, and then name each table. This is not ok :)
Hi Vickie,
It is not recommended to use OData to get data from F&O into Power BI. It is recommended to get data in a data lake or BYOD database. OData isn't giving the best performance for high transaction volumes.
Here is some documentation:
docs.microsoft.com/.../export-entities-to-your-own-database
docs.microsoft.com/.../azure-data-lake-overview
If you really want to go forward with OData, you can use a parameter to enable cross-company statements: docs.microsoft.com/.../odata
Share
Report
All responses (
Answers (
