Dataverse connector for Excel


Recently, Microsoft announced dataverse connector for excel. With this new connector, customers and partners can create report in excel based on Dataverse data. Lets see, how we can use this dataverse connector in excel.

Step 1: Open your excel and click on Data.

You can see new menu is available for Power Platform. When you click on this then you can three different options.

Step 2 : Click on Dataverse and login with your organization account.

You will see dataverse environment connected with your account.

Select the dataverse environment and add your entities for reporting.

Note : You cannot access virtual entities with the dataverse connector.

I created a sample HR dashboard with this new dataverse connector.

If you like this article, feel free to share it with others who might find it helpful! If you have any questions, feel free to reach out to me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: