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?

Subscribe to
The Daily Friction

A daily newsletter on automation and eliminating friction

Related Content

Improving Optimization?

Improving Optimization? The traditional steps of Optimization: 1. Eliminate 2. Automate or 3. Delegate What if we added a missing element? Simplify. Before automating a convoluted workflow or delegating a tangled task, strip away the unnecessary. Make processes leaner...

read more

Unit tests for Dataverse plugins?

Unit tests for Dataverse plugins? I must admit, I almost never write unit tests for Dataverse plugins. Plugins are often quite simple, testing them in isolation is not particularly useful. Often you only test a couple of if-statements. Unit tests don't bring a lot of...

read more

New Dynamics 365 browser extension

New Dynamics 365 browser extension I'm trying out the new -Power Roles- extension and it looks very promising. You browse to a Dynamics 365 (or Power Apps) app and then you press -record-. It will then monitor all the action you do in the app and propose which...

read more