skills.rest
sigmacomputing
sigmacomputingOFFICIAL
Explore all skills by this author →
WebsiteGitHub

powerbi-assessment

Inventory Power BI and Fabric tenant assets to generate migration-readiness reports.

6|7|Updated Dec 14, 2023
Search Tags:#migration#assessment#inventory#fabric#dax#sigma#powerbi
One-click install
npx skills add https://github.com/sigmacomputing/quickstarts-public --skill powerbi-assessment
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-assessment
Source: https://github.com/sigmacomputing/quickstarts-public/tree/main/powerbi-migration-skills/powerbi-assessment
Command: npx skills add https://github.com/sigmacomputing/quickstarts-public --skill powerbi-assessment

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires msal, requests, truststore, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill solves the complexity of scoping a migration from Power BI to Sigma by automatically inventorying tenant assets and identifying which reports are ready for conversion versus those requiring manual rework.

Core Features & Use Cases

  • Automated Inventory: Scans workspaces, semantic models, and reports to provide a comprehensive view of BI sprawl.
  • Complexity Scoring: Analyzes DAX expressions and visual configurations to rank reports by migration effort and value.
  • Migration Planning: Generates a data-driven shortlist and migration plan that can be directly consumed by the powerbi-to-sigma conversion skill.

Quick Start

Run the powerbi-assessment skill to inventory your current tenant and generate a migration readiness report in your local directory.

Frequently Asked Questions about powerbi-assessment

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

FAQPage Schema
How do I assess Power BI tenant readiness before migrating to Sigma?▼

Assess Power BI tenant readiness by automatically inventorying workspaces, semantic models, and reports to produce a migration-readiness readout. This process analyzes DAX complexity and visual configurations to determine conversion feasibility and identify which reports require manual rework.

What is the best way to inventory Power BI and Fabric assets for migration planning?▼

Inventorying Power BI and Fabric assets involves scanning tenant workspaces to provide a comprehensive view of BI sprawl. This automated inventory generates a data-driven shortlist and migration plan by clustering reports based on shared semantic models.

How does DAX complexity scoring work for Power BI migration?▼

DAX complexity scoring works by analyzing semantic model expressions and report visual configurations to rank reports by migration effort and value. This scoring determines conversion feasibility, helping you identify which reports are ready for migration versus those needing manual rework.

Can I generate a machine-readable migration plan from Power BI to Sigma?▼

You can generate a machine-readable migration plan by inventorying Power BI tenant assets and analyzing DAX complexity. The resulting plan clusters reports by shared semantic models and can be directly consumed by downstream conversion tools.

Do I need Microsoft Authentication Library to audit Power BI workspaces?▼

Auditing Power BI workspaces requires Microsoft Authentication Library (msal) and requests libraries to authenticate and scan tenant assets. These dependencies enable the inventory process to access workspaces, semantic models, and reports for migration readiness analysis.

Which Power BI reports should I migrate first to Sigma?▼

Identify which Power BI reports to migrate first by using complexity scoring to rank reports by migration effort and value. This value-ranked shortlist highlights reports ready for conversion based on DAX complexity and visual configuration analysis.

Related Skills

Explore More Data & Analytics Skills→
wardawgmalviciouswardawgmalvicious
2

fabric-auth

Configure authentication tokens for Microsoft Fabric APIs with correct audiences.

Community
Intermediate
sigmacomputingsigmacomputing
6

powerbi-to-sigma

Migrate Power BI semantic models and report layouts into Sigma data models and workbooks.

Official
Advanced
rritecrritec
3

dataflows-save-as-authoring-cli

Assess Gen1 dataflow readiness and create Gen2.1 copies via Power BI and Fabric REST APIs.

Community
Advanced
patrikboroschpatrikborosch
14

fabriciq

Answer natural language questions about Power BI report data via FabricIQ.

Community
Advanced