Almanac
Microsoft/dataversePower Platform

Consultant KB for Microsoft Dataverse, the data layer under Dynamics 365 and the Power Platform: data model, security model, business logic, APIs and integration, search and queries, analytics and Fabric, ALM and solutions, administration, governance and compliance, and Dataverse as an agent data platform, plus cross-cutting decision guides. Implementation notes, configuration decisions and the gotchas that bite on real projects. Populated by the daily author agent from the Dataverse release plans, docs repo and product blog, plus the author's own consultant notes.

9 versions · FEATURES.md
v9🤖 markdown-import19 hours agomarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
- | 2026-09-16 | Updated: **Azure Synapse Link for Dataverse** — deleted-record retention in the lake: in append only (and Delta Lake) output a delete is a soft `isDeleted = True` tombstone that Synapse Link hard-deletes after 30 days, so a lake used as the audit trail silently loses deleted history; long-term retention on the Dataverse table is the fix. |
+ | 2026-09-16 | Updated: **Azure Synapse Link for Dataverse** — deleted-record retention in the lake: in append only (and Delta Lake) output a delete is a soft `isDeleted = True` tombstone that Synapse Link hard-deletes after 30 days, so a lake used as the audit trail silently loses deleted history; long-term retention on the Dataverse table is the fix. Updated: **Admin APIs and automation** — Power Platform API known limitations: RBAC covers only a named subset of endpoints (all Power Pages, environment management except the two *for User* reads, governance except cross-tenant connection reports), and sovereign-cloud availability for lifecycle endpoints is scheduled for 1 December 2026. |
| 2026-09-15 | New: **Plug-in Trace Log** — Business Logic; the `PluginTraceLog` table end to end (Off/Exceptions/All setting, 10 KB MessageBlock truncation, 24-hour retention, 100 GB cut-off) including Microsoft's September 2026 change restricting read access to `MessageBlock`, `Configuration` and `SecureConfiguration` to System Administrator. Updated: **Table relationships** — added the lookup primary-name disclosure gotcha: anyone who can read the row holding a lookup sees the related record's primary name whether or not they can read that record. |
| 2026-09-10 | Updated: **Azure Synapse Link for Dataverse** — Delta Lake (Parquet) export deprecated: closed to new customers 15 Oct 2026, removed Dec 2027, replacement is Link to Fabric. Updated: **Low-latency sync** — SQL analytics endpoint metadata sync v2 (preview, new workspace connections only), CDF latency tradeoff, and unlink now fails while dependent Fabric artefacts exist. |
| 2026-08-30 | New: **Dataverse SDK for Python** (Public Preview) — APIs & Integration; Python package (`PowerPlatform-Dataverse-Client`) for direct Dataverse access with CRUD, native bulk operations, QueryBuilder, table metadata CUD and Pandas DataFrame results — no .NET required. |
v8🤖 markdown-import19 hours agomarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-09-16 | Updated: **Azure Synapse Link for Dataverse** — deleted-record retention in the lake: in append only (and Delta Lake) output a delete is a soft `isDeleted = True` tombstone that Synapse Link hard-deletes after 30 days, so a lake used as the audit trail silently loses deleted history; long-term retention on the Dataverse table is the fix. |
| 2026-09-15 | New: **Plug-in Trace Log** — Business Logic; the `PluginTraceLog` table end to end (Off/Exceptions/All setting, 10 KB MessageBlock truncation, 24-hour retention, 100 GB cut-off) including Microsoft's September 2026 change restricting read access to `MessageBlock`, `Configuration` and `SecureConfiguration` to System Administrator. Updated: **Table relationships** — added the lookup primary-name disclosure gotcha: anyone who can read the row holding a lookup sees the related record's primary name whether or not they can read that record. |
| 2026-09-10 | Updated: **Azure Synapse Link for Dataverse** — Delta Lake (Parquet) export deprecated: closed to new customers 15 Oct 2026, removed Dec 2027, replacement is Link to Fabric. Updated: **Low-latency sync** — SQL analytics endpoint metadata sync v2 (preview, new workspace connections only), CDF latency tradeoff, and unlink now fails while dependent Fabric artefacts exist. |
| 2026-08-30 | New: **Dataverse SDK for Python** (Public Preview) — APIs & Integration; Python package (`PowerPlatform-Dataverse-Client`) for direct Dataverse access with CRUD, native bulk operations, QueryBuilder, table metadata CUD and Pandas DataFrame results — no .NET required. |
v7🤖 markdown-importyesterdaymarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-09-15 | New: **Plug-in Trace Log** — Business Logic; the `PluginTraceLog` table end to end (Off/Exceptions/All setting, 10 KB MessageBlock truncation, 24-hour retention, 100 GB cut-off) including Microsoft's September 2026 change restricting read access to `MessageBlock`, `Configuration` and `SecureConfiguration` to System Administrator. Updated: **Table relationships** — added the lookup primary-name disclosure gotcha: anyone who can read the row holding a lookup sees the related record's primary name whether or not they can read that record. |
| 2026-09-10 | Updated: **Azure Synapse Link for Dataverse** — Delta Lake (Parquet) export deprecated: closed to new customers 15 Oct 2026, removed Dec 2027, replacement is Link to Fabric. Updated: **Low-latency sync** — SQL analytics endpoint metadata sync v2 (preview, new workspace connections only), CDF latency tradeoff, and unlink now fails while dependent Fabric artefacts exist. |
| 2026-08-30 | New: **Dataverse SDK for Python** (Public Preview) — APIs & Integration; Python package (`PowerPlatform-Dataverse-Client`) for direct Dataverse access with CRUD, native bulk operations, QueryBuilder, table metadata CUD and Pandas DataFrame results — no .NET required. |
| 2026-08-21 | New: **Dataverse Plugin for AI Coding Agents** (Public Preview) — AI & Agent Data Platform; open-source skill set that lets GitHub Copilot/Claude Code/Cursor/Codex drive the Dataverse CLI, MCP server, Python SDK, Power Platform CLI and Web API from natural-language prompts. |
… 7 unchanged lines …
| -------- | ---- |
| Data Model | 9 |
| Security Model | 8 |
- | Business Logic | 7 |
+ | Business Logic | 8 |
| APIs & Integration | 8 |
| Search & Queries | 5 |
| Analytics & Fabric | 6 |
… 2 unchanged lines …
| Governance & Compliance | 6 |
| AI & Agent Data Platform | 6 |
| Decision & Selection Guides | 6 |
- | **Total** | **74** |
+ | **Total** | **75** |
v6🤖 markdown-import6 days agomarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-09-10 | Updated: **Azure Synapse Link for Dataverse** — Delta Lake (Parquet) export deprecated: closed to new customers 15 Oct 2026, removed Dec 2027, replacement is Link to Fabric. Updated: **Low-latency sync** — SQL analytics endpoint metadata sync v2 (preview, new workspace connections only), CDF latency tradeoff, and unlink now fails while dependent Fabric artefacts exist. |
| 2026-08-30 | New: **Dataverse SDK for Python** (Public Preview) — APIs & Integration; Python package (`PowerPlatform-Dataverse-Client`) for direct Dataverse access with CRUD, native bulk operations, QueryBuilder, table metadata CUD and Pandas DataFrame results — no .NET required. |
| 2026-08-21 | New: **Dataverse Plugin for AI Coding Agents** (Public Preview) — AI & Agent Data Platform; open-source skill set that lets GitHub Copilot/Claude Code/Cursor/Codex drive the Dataverse CLI, MCP server, Python SDK, Power Platform CLI and Web API from natural-language prompts. |
| 2026-08-18 | New: **Planning Latency for Link to Fabric** — Analytics & Fabric; indicative P95 data-freshness reference by load pattern. |
v5🤖 markdown-import2 weeks agomarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-08-30 | New: **Dataverse SDK for Python** (Public Preview) — APIs & Integration; Python package (`PowerPlatform-Dataverse-Client`) for direct Dataverse access with CRUD, native bulk operations, QueryBuilder, table metadata CUD and Pandas DataFrame results — no .NET required. |
| 2026-08-21 | New: **Dataverse Plugin for AI Coding Agents** (Public Preview) — AI & Agent Data Platform; open-source skill set that lets GitHub Copilot/Claude Code/Cursor/Codex drive the Dataverse CLI, MCP server, Python SDK, Power Platform CLI and Web API from natural-language prompts. |
| 2026-08-18 | New: **Planning Latency for Link to Fabric** — Analytics & Fabric; indicative P95 data-freshness reference by load pattern. |
| 2026-08-06 | New: **Custom column visualizations for grids** (Public Preview) — Data Model. |
… 6 unchanged lines …
| Data Model | 9 |
| Security Model | 8 |
| Business Logic | 7 |
- | APIs & Integration | 7 |
+ | APIs & Integration | 8 |
| Search & Queries | 5 |
| Analytics & Fabric | 6 |
| ALM & Solutions | 6 |
… 1 unchanged line …
| Governance & Compliance | 6 |
| AI & Agent Data Platform | 6 |
| Decision & Selection Guides | 6 |
- | **Total** | **73** |
+ | **Total** | **74** |
v4🤖 markdown-import3 weeks agomarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-08-21 | New: **Dataverse Plugin for AI Coding Agents** (Public Preview) — AI & Agent Data Platform; open-source skill set that lets GitHub Copilot/Claude Code/Cursor/Codex drive the Dataverse CLI, MCP server, Python SDK, Power Platform CLI and Web API from natural-language prompts. |
| 2026-08-18 | New: **Planning Latency for Link to Fabric** — Analytics & Fabric; indicative P95 data-freshness reference by load pattern. |
| 2026-08-06 | New: **Custom column visualizations for grids** (Public Preview) — Data Model. |
| 2026-07-22 | Initial backfill — 70 docs published across all eleven categories. |
… 11 unchanged lines …
| ALM & Solutions | 6 |
| Administration | 7 |
| Governance & Compliance | 6 |
- | AI & Agent Data Platform | 5 |
+ | AI & Agent Data Platform | 6 |
| Decision & Selection Guides | 6 |
- | **Total** | **72** |
+ | **Total** | **73** |
v3🤖 markdown-import4 weeks agomarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-08-18 | New: **Planning Latency for Link to Fabric** — Analytics & Fabric; indicative P95 data-freshness reference by load pattern. |
| 2026-08-06 | New: **Custom column visualizations for grids** (Public Preview) — Data Model. |
| 2026-07-22 | Initial backfill — 70 docs published across all eleven categories. |
… 6 unchanged lines …
| Business Logic | 7 |
| APIs & Integration | 7 |
| Search & Queries | 5 |
- | Analytics & Fabric | 5 |
+ | Analytics & Fabric | 6 |
| ALM & Solutions | 6 |
| Administration | 7 |
| Governance & Compliance | 6 |
| AI & Agent Data Platform | 5 |
| Decision & Selection Guides | 6 |
- | **Total** | **71** |
+ | **Total** | **72** |
v2🤖 markdown-importlast monthmarkdown import
… 3 unchanged lines …
| Date | Change |
| ---- | ------ |
+ | 2026-08-06 | New: **Custom column visualizations for grids** (Public Preview) — Data Model. |
| 2026-07-22 | Initial backfill — 70 docs published across all eleven categories. |
## By category
| Category | Docs |
| -------- | ---- |
- | Data Model | 8 |
+ | Data Model | 9 |
| Security Model | 8 |
| Business Logic | 7 |
| APIs & Integration | 7 |
… 4 unchanged lines …
| Governance & Compliance | 6 |
| AI & Agent Data Platform | 5 |
| Decision & Selection Guides | 6 |
- | **Total** | **70** |
+ | **Total** | **71** |
v1🤖 markdown-importlast monthmarkdown import
Initial version.