If you work with Microsoft Dataverse or build Power Platform solutions and you’re not using XrmToolBox you’re missing out.
Whether you’re a Power Platform developer, architect, or engineer, XrmToolBox can dramatically improve your productivity, simplify complex tasks, and give you access to hundreds of community-built tools. In this post, we’ll explore what XrmToolBox is, why it’s essential, and how to connect it to your environments. We’ll also look at three of the most powerful tools inside the toolbox: SQL 4 CDS, FetchXML Builder, and Data Transporter.
What Is XrmToolBox?
XrmToolBox is a free, community-supported Windows application that connects to all your Microsoft Dataverse environments. Think of it as a Swiss Army knife for Dataverse packed with hundreds of specialized tools designed to make development, administration, and troubleshooting faster and easier.
You can download it from the official site: xrmtoolbox.com. Once installed, it opens just like any other Windows app.
Inside XrmToolBox
- Start Page Get quick access to your favorite and recently used tools.
- Installed Tools A searchable list of pre-installed utilities.
- Tool Library A massive repository of community-developed plugins that can be added in seconds.
You can filter by Microsoft MVP tools, browse newly released utilities, or discover the ones most popular in the Dataverse community.
Connecting XrmToolBox to Microsoft Dataverse
Before using any tool, you’ll need to connect XrmToolBox to your Dataverse environment.
Here’s how:
- Click Create a New Connection in the bottom left corner.
- Choose Connection Wizard for the simplest setup.
- Enter your environment URL, which you can find at
- make.powerapps.com, or
- admin.powerplatform.microsoft.com.
- Use your Microsoft 365 credentials.
- (Optional) Save your password as an encrypted string so you don’t need to re-enter it each time.
Once connected, you’re ready to explore hundreds of productivity-enhancing tools.
Must-Have Tools in XrmToolBox
Let’s look at three essential tools every Power Platform professional should know.
1. SQL 4 CDS Query Dataverse Like a Pro
If you come from a SQL or database administration background, this tool will feel like home.
SQL 4 CDS lets you:
- Write SQL queries directly against your Dataverse data.
- Perform bulk operations (insert, update, delete).
- Convert SQL queries to FetchXML for integration with other tools.
Example:
SELECT * FROM accounts WHERE address1_stateorprovince = 'New York'
You can run this query, view results instantly, and even export or transform the query into FetchXML for use in other contexts like Power Automate or model-driven apps.
2. FetchXML Builder Design Advanced Queries Visually
FetchXML Builder is a visual query designer that lets you build complex Dataverse queries without writing a single line of code. It’s perfect for those creating advanced views or flows in Power Automate.
Top features include:
- Build queries with filters, joins, and related entities.
- Convert queries to OData or FetchXML for Power Automate.
- Save queries as system or personal views directly inside Dataverse.
- Generate JavaScript or C# code for developers.
This tool also reveals advanced operators you might not know exist like filtering by fiscal period, time ranges, or relative dates.When working with Power Automate, you can generate both OData and FetchXML parameters directly from FetchXML Builder then paste them into your flow to optimize query performance.
3. Data Transporter Effortless Data Migration Between Environments
When you’re managing multiple environments Dev, Test, and Production the Data Transporter tool is a lifesaver.
It lets you:
- Migrate tables and records from one environment to another.
- Automatically map user references between environments.
- Move data table by table or in playlists (groups of tables).
- Control what gets updated or created without deleting records.
If you’ve ever used Microsoft’s Configuration Migration Tool, you’ll find Data Transporter much more intuitive and reliable. It’s especially useful for testing data migrations before pushing changes live.
Migration Tip:
If you encounter lookup reference errors, migrate without lookup columns first, then rerun the process including them. This ensures referenced records exist before relationships are created.
Why XrmToolBox Is a Game-Changer
XrmToolBox eliminates countless manual steps from your day-to-day Dataverse and Power Platform work.
It’s:
- Free and community-driven.
- Extensible, with new tools added regularly.
- Powerful, giving non-developers and developers alike the ability to handle complex operations visually.
Whether you’re editing model-driven app ribbons, building Power Automate filters, or migrating data, XrmToolBox saves you time, effort, and frustration.
Final Thoughts
If you’re working with Microsoft Dataverse or Power Platform, make XrmToolBox part of your toolkit today. Start with these three tools:
- SQL 4 CDS
- FetchXML Builder
- Data Transporter
From there, explore the hundreds of other tools created by the community. Once you start using it, you’ll wonder how you ever managed without it.
Further Learning
Want to level up your Power BI and Power Platform skills?
Explore Power BI Training at Data Bear
