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.

Some Concepts:

• OData
• OData in D365
• Connecting to OData in Excel through Power Query
• Data entity names are case sensitive and likely need dataareaid (legal enitity) defined.

Some References:

• The Matrix

Additional Resources:

• D365 Finance | Excel Add-in Data Connector from Scratch
• D365 Finance | Excel Add-in Reports with Formulas
• D365 Finance | Supercharge Excel Add-in with Power Query
• Open Data Protocol (OData) in D365 Finance (MS)
• Excel Power‌ Query Tutorial (Excel Champs)
• Power Query Documentation (MS)