Writing SQL Queries for Dataverse – SELECT, WHERE, LIKE and More

In my previous post, I introduced an interesting addition to the Dataverse developer toolbox: the ability to send SQL queries through the Dataverse Web API. Knowing that SQL is available is one thing. Actually writing queries with it is where things start getting interesting. At first glance, the syntax feels immediately familiar: SELECT name, telephone1 … Continue reading Writing SQL Queries for Dataverse – SELECT, WHERE, LIKE and More →

SQL Meets the Dataverse Web API – Query Dataverse Using SQL

If you have been working with Microsoft Dataverse for a while, querying data usually means reaching for one of a few familiar options. You might use FetchXML when building more complex Dataverse queries. You might use OData when working directly with the Dataverse Web API. And depending on the scenario, you may also have used … Continue reading SQL Meets the Dataverse Web API – Query Dataverse Using SQL →

Dataverse Service Protection Limits – Why 6,000 Requests Is Only Part of the Story

If you've worked with Dataverse integrations long enough, you've probably encountered this number: 6,000 requests in five minutes. It often gets repeated as: "The Dataverse API limit is 6,000." But after the previous articles in this series, we should already know why that statement needs more context. Dataverse doesn't have one simple API limit. The … Continue reading Dataverse Service Protection Limits – Why 6,000 Requests Is Only Part of the Story →

What Actually Counts as a Power Platform Request?

Why a simple Power Automate flow can quietly consume thousands of Power Platform Requests? The Biggest Misconception One of the biggest misunderstandings in Power Platform is believing that: One Flow = One Request Unfortunately... That's almost never true. A single business action can trigger dozens or even hundreds of Power Platform requests, depending on how … Continue reading What Actually Counts as a Power Platform Request? →

Designing Searchable Experiences: Mastering the Quick Find View

"A search engine is only as good as the information it has been told to search." In the previous article, we explored how administrators decide which tables participate in the Dataverse Search Index. We learned that not every table belongs in the search index, and that careful planning is essential for building a scalable and … Continue reading Designing Searchable Experiences: Mastering the Quick Find View →

Designing Searchable Tables: A Deep Dive into the Dataverse Search Index

In the previous articles, we explored the search-related settings available in the Power Platform Admin Center and learned how Search Indexing, Global Search, Quick Find, and Microsoft 365 integration work together to deliver a modern search experience. Now we arrive at one of the most important questions in the entire series: How does Dataverse decide … Continue reading Designing Searchable Tables: A Deep Dive into the Dataverse Search Index →

Optimising Dataverse Search: Understanding the Search Settings in Power Platform

"Enabling Dataverse Search is only the beginning. The real user experience is shaped by how you configure the search behaviour." In the previous article, we explored the Dataverse Search section in the Power Platform Admin Center and learned how Search Indexing, the Global Search Bar, and Search-Only Experiences work together to build the foundation for … Continue reading Optimising Dataverse Search: Understanding the Search Settings in Power Platform →

Building the Foundation: Understanding Dataverse Search Configuration

"Search isn't just a feature anymore it's becoming the foundation for AI, Copilot, and intelligent experiences across Microsoft Power Platform." Throughout this series, we have explored how Dataverse Search works behind the scenes from search indexing and relevance ranking to facets, filters, and the search pipeline. But before any of that can happen, there is … Continue reading Building the Foundation: Understanding Dataverse Search Configuration →

Why This Record Appears First: Understanding Relevance Ranking, Facets, and Filters in Dataverse Search

In the previous article, we explored how Dataverse prepares searchable information behind the scenes so users can search across multiple tables almost instantly. But another question naturally follows: When several records match my search, why does one appear at the top while another appears further down the list? The answer lies in relevance ranking, along … Continue reading Why This Record Appears First: Understanding Relevance Ranking, Facets, and Filters in Dataverse Search →

Dataverse Search vs Quick Find vs Advanced Find – Choosing the Right Search for the Right Job

By now, we have uncovered two important truths about Dataverse Search. First, it doesn't search the database directly. Second, it relies on a dedicated search index that is continuously maintained in the background. But if Dataverse Search is so powerful, why do Quick Find and Advanced Find still exist? It's a question many developers ask … Continue reading Dataverse Search vs Quick Find vs Advanced Find – Choosing the Right Search for the Right Job →