dv-query

Name: dv-query
Availability: InStock
Author: Microsoft

Retrieve and analyze Dataverse records using the Python SDK and Web API.

195|50|Updated Mar 11, 2026

Search Tags:#sdk #aggregation #query #pagination #dataframe #expand #dataverse

Ready to run

npx skills add https://github.com/microsoft/Dataverse-skills --skill dv-query

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dv-query
Source: https://github.com/microsoft/Dataverse-skills/tree/main/.github/plugins/dataverse/skills/dv-query
Command: npx skills add https://github.com/microsoft/Dataverse-skills --skill dv-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires PowerPlatform-Dataverse-Client, and includes scripts (resource) components.

What problem does it solve?

Bulk reads, multi-page iteration, and analytics across Dataverse records using the Python SDK and Web API, enabling efficient data access and analysis without manual pagination.

Core Features & Use Cases

SDK-first reads for safe, authenticated access to Dataverse data.
Support for multi-page queries, $expand, and $apply aggregations to answer complex questions and cross-table scenarios.
DataFrame handoff with client.dataframe.get() for analysis, notebooks, and export to CSV/Excel.

Quick Start

Query records from a table using the Python SDK and load results into a pandas DataFrame.

Frequently Asked Questions about dv-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I query Dataverse records and load them into a pandas DataFrame?▼

You can query Dataverse records and load them into a pandas DataFrame using the Python SDK's client.dataframe.get() method, which handles authenticated access and efficiently hands off data for analysis.

What is the best way to handle pagination when retrieving bulk Dataverse data?▼

To handle pagination when retrieving bulk Dataverse data, use the Python SDK's multi-page query capabilities, which automatically manage paging across large record sets without manual iteration logic.

Can I perform cross-table queries and aggregations using the Dataverse Web API?▼

Yes, you can perform cross-table queries and aggregations using the Dataverse Web API by applying server-side options like $expand for related tables and $apply for aggregations to answer complex questions.

Do I need the Dataverse SDK to run server-side queries in Python?▼

Yes, you need the Dataverse SDK and Python environment to execute safe, authenticated server-side queries, with optional pandas required to structure returned records into DataFrames for notebook analysis.

Does the Dataverse Python SDK support multi-page iteration and $apply aggregations?▼

The Dataverse Python SDK supports multi-page iteration and $apply aggregations, enabling users to retrieve bulk records and compute server-side aggregations across single-table and cross-table queries.

Why use a QueryBuilder for Dataverse data analysis instead of manual API calls?▼

Using a QueryBuilder for Dataverse data analysis instead of manual API calls ensures safe authenticated access, streamlines complex server-side options, and directly structures results for DataFrame handoff.