- Open Excel and go to the Data tab. Click on New Query | From other source | From OData feed:
- In the next screen add your Dynamics 365 API URL, add /data at the end of the URL, and click OK:
- It will navigate you to the next screen where we need to select three tables, as shown in the following screenshot:
When you click the Load button, all queries will load on your Excel file right away. You can select every query for an ...