web
You’re offline. This is a read only version of the page.
close

Dataverse to Power BI Semantic Model

Description

Extract Dataverse metadata and generate Power BI TMDL/PBIP semantic models with automatic table relationships, calendar tables, and incremental change detection.

Latest version release notes

v1.2026.5.84 — Fixed expanded-lookup SQL JOIN generation to always use related table logical/schema names (not display names), preventing invalid SQL when views include related-table columns.
v1.2026.5.83 — Quick Select now preserves current All/Selected filter mode and refreshes selections in-place. Fixed selected-attribute persistence after reopen by using case-insensitive selection sets and removing view-mode default reapply during metadata load/revalidation. Expanded child row Default checkmarks now require strict selected-view linked-column matches. Added automatic normalization/upgrade of saved expanded lookup display metadata on load.
v1.2026.5.62 — Fixed FabricLink expanded multi-select label resolution: uses OUTER APPLY + STRING_SPLIT + STRING_AGG with metadata JOINs (matching regular multi-select behavior).
v1.2026.5.61 — Expand Lookups: denormalize related table fields via LEFT OUTER JOIN. CSV documentation export for model review/audit. Export flow redesign (JSON or CSV format selection).
v1.2026.5.60 — Fixed FabricLink multi-select choice label joins (semicolon split + OptionSetName uses attribute logical name).
v1.2026.5.56 — Updated package metadata and icons - fixed problem with CR/LF in description fields causing schema validation errors in Power BI Desktop.
v1.2026.5.54 — Renamed repository and updated package metadata.
v1.2026.5.37 — Bug fix release addressing TMDL compatibility and relationship dialog stability.

Bug Fixes Since v1.2026.5.21:
- Fixed Power BI Desktop schema validation errors caused by 'description' properties on relationships (not supported in Feb 2026 builds)
- Fixed automatic resolution of ambiguous relationship paths (multiple active relationships to same target now auto-resolved)
- Fixed NullReferenceException crashes in relationship selector dialog when checking/unchecking relationships
- Fixed relationship active/inactive state tracking to use tag property instead of ListView control state
- Fixed "Solution tables only" filter hiding already-selected relationships to out-of-solution tables
- Fixed duplicate 'mode:' line in generated table partition TMDL
- Added user confirmation prompts when selecting relationships that conflict with existing active relationships

Previous Release (v1.2026.5.21):
- Storage Mode Support — DirectQuery, Dual (All/Select), and Import mode per semantic model with per-table overrides
- Export/Import Configurations — Share model configs as JSON files between machines or team members
- Change Preview Redesign — Grouped TreeView with impact analysis, filter toggles, and detail pane
- Incremental Update Preservation — LineageTags, user relationships, column descriptions, formatting, annotations preserved
- Table Rename Detection — Detects renamed tables and carries over customizations
- Vista Folder Picker — Modern Explorer-style folder dialogs
- Date Relationship Dedup — Stale date relationships automatically cleaned up
- Attribute List Performance — Pre-sorted cache for instant table/filter switching

Versions

Version Release date Number of downloads Rating
1.2026.5.84 2/20/2026 8:27:05 PM 0 0
1.2026.5.83 2/20/2026 6:35:43 PM 0 0
1.2026.5.63 2/20/2026 1:23:43 AM 0 0
1.2026.5.60 2/19/2026 4:29:26 PM 0 0
1.2026.5.57 2/18/2026 8:15:14 PM 25 0
Show more versions (18 more)

Ratings

Latest version

No feedback yet. Add yours

Other versions

No feedback.

Related information

Author: Scott Sewell Latest version: 1.2026.5.84 Released on: 02/20/2026 Nuget package Id: DataverseToPowerBI.XrmToolBox Open Source: true Go to project web site Ratings (all versions) 0Average rating 0Number of ratings Downloads 0Latest version 366All versions 15.91Average per version Tags Data Power BI