Welcome to the matrix!
In this video, we look at how D365 data entities work with OData, how to find the entities available to you through OData, and how to connect to those entities using Power Query in Excel.
- OData in D365
- Connecting to OData in Excel through Power Query
- Data entity names are case sensitive and likely need dataareaid (legal enitity) defined.