Monday, March 11, 2024

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
Dataverse connector in Excel

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

No comments:

Post a Comment