How to use Power Query in Excel and connect to D365 CE (Part 2: Dataverse connector)

Microsoft has a released a new way to connect to Dynamics 365 via the Dataverse connector. To use the dataverse connector follow these steps:

• Open Excel > Data > Get Data > From Power Platform > From Dataverse

• Login using the user who has access to the data.
• Select one or multiple tables as required.
• Transform and Load data.

Hope it helps!