5 ways to find data in Dataverse

by Oct 19, 2022

5 ways to find data in Dataverse.

How to find data in Datavers from simple to most powerful way:

βœ… Dataverse Search

In the middle on top there is a big Search bar, which is sometimes overlooked. It has great power to find what you ask for. Not yet enabled? Do it in the Power Platform Admin Center.

βœ… Modern Advanced Find

To go-to way to find data for users. Now it’s being modernized and moved to the Search bar. Open it and click on the text ‘Search for rows in a table using advanced filters’. It’s also available on each view by the button ‘Edit filters’.

With the Level Up chrome extension, it’s still possible to navigate to the Legacy Advanced Find 🀫.

βœ… FetchXML Builder in the XrmToolBox

The go-to tool for most consultants in this world. FetchXML is the query language of Dataverse and this tool makes it easy to create it and run it.

βœ… SQL 4 CDS in the XrmToolBox

My new favorite tool to find data, created by Mark Carrington. You can now dust off your SQL knowledge that you used on-premises and apply it to Dataverse.

It integrates well with FetchXML Builder so you can go back and forth between both tools.

The magical feature is that it also supports INSERT-, UPDATE- and DELETE-statements!

βœ… Excel and Power BI

For doing real analysis we can also use Excel and Power BI to connect with Dataverse. When connected you can use Power Query to go through your data.

What is your favorite tool? Did I miss any?

Remy van Duijkeren

Remy van Duijkeren

Power Platform Advisor

Microsoft Power Platform Advisor with over 25 years of experience in IT with a focus on (marketing) automation and integration.

Helping organizations with scaling their business by automating processes on the Power Platform (Dynamics 365).

Expert in Power Platform, Dynamics 365 (Marketing & Sales) and Azure Integration Services. Giving advice and strategy consultancy.

Services:
– Strategy and tactics advise
– Automating and integrating

Subscribe to
The Daily Friction

A daily newsletter on automation and eliminating friction

Related Content

Newsletter subscribers can grow cold. It happens. πŸ₯Ά

Newsletter subscribers can grow cold. It happens. πŸ₯Ά Every 3 to 6 months, check who's engaging (opens, clicks). Use automation to tag those who haven't engaged in a month or two. Send them a "We're about to remove you" email. Let them know it's okay if they're not...

read more