PowerTools

FetchXML Tester

Paste a FetchXML query, run it as written, and keep a local library of the queries you use.

A modern take on the XrmToolBox FetchXml Tester workflow, built into PowerTools.

Download for Windows View on GitHub

Run FetchXML exactly as written

FetchXML Tester is a fast way to run a FetchXML query against Dataverse or Dynamics 365. Paste the query, format it, and run it. The results appear in a grid with the row count and whether more records exist beyond the first page.

Nothing rewrites your query. What you paste is what runs, which makes it ideal for checking FetchXML copied from code, a view, a report, or a flow.

Raw or formatted values

Turn on Show formatted values to see option labels, lookup names, and formatted dates and currency instead of raw values.

A library of your queries

Save a query with a description and it goes into a local library on your machine. Search the library by table, description, query text, or environment, and load a saved query with a double click. You can see the queries for the current environment or for all of them.

When to use it

  • Debugging FetchXML from a plug-in or a Power Automate flow.
  • Keeping a personal set of diagnostic queries for each environment.
  • Running a query you built in FetchXML Builder with hand edits.

More tools

Also in PowerTools

Attribute Explorer

Browse every table in an environment and inspect its fields, types, and lookups.

Bulk Workflow Execution

Run an on-demand workflow against every record a view or FetchXML query returns, in batches you can pace and stop.

Data Migration

Move data between Dataverse environments with a guided, developer-friendly workflow that is easier to understand and control.

FetchXML Builder

Build, test, and refine FetchXML queries in a cleaner workspace built for fast iteration.

Plugin Registration

Browse and manage plug-in assemblies, types, steps, and images.

Polymorphic Lookup Creator

Create, update, and delete polymorphic lookups in the selected environment.

Solution Components Mover

Copy solution components from selected solutions into unmanaged solutions in the same environment.

Solution Layers Explorer

See every solution layer of a Dataverse component, compare any two layers side by side, and remove the unmanaged Active layer.

Translator

Edit the display names and descriptions of tables, columns, choices, views, and charts side by side in every language installed in an environment.

Workflow Activities Viewer

See which activated processes reference a custom workflow activity.