skills.rest
RajaPoseidon
RajaPoseidonCOMMUNITY
Explore all skills by this author →
GitHub

import_powerbi

Import Power BI .pbit and .pbix files into Snowflake Semantic Views.

Updated Jun 9, 2025
Search Tags:#migration#snowflake#dax#semantic view#powerbi#yaml export#pbix
One-click install
npx skills add https://github.com/RajaPoseidon/snippets_repo --skill import-powerbi-rajaposeidon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: import_powerbi
Source: https://github.com/RajaPoseidon/snippets_repo/tree/main/snowflake/skills/import_powerbi
Command: npx skills add https://github.com/RajaPoseidon/snippets_repo --skill import-powerbi-rajaposeidon

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve? Migrating Power BI dashboards to Snowflake requires manually translating tables, relationships, and DAX measures into semantic models, which is slow and error-prone. This Skill automates the analysis and conversion of Power BI files into Snowflake Semantic View YAML. ## Core Features & Use Cases - File Analysis: Parse .pbit and .pbix files staged in Snowflake to inventory tables, columns, measures, relationships, and M-query warnings before conversion. - Filtered Export: Generate Semantic View YAML with options to include specific tables, columns, or measures, remap target databases/schemas, and drop unsupported DAX measures. - Validation & Remapping: Verify base table references exist in Snowflake and re-export with target database/schema overrides when migrating across environments. - Use Case: A data team migrating a sales dashboard from Power BI to Snowflake uploads the .pbix file to a stage, analyzes its 20 tables and 50 DAX measures, filters to the relevant tables, and exports a semantic model YAML ready for deployment. ## Quick Start Import the Power BI file @ANALYTICS.PUBLIC.MY_STAGE/sales_dashboard.pbix into a Snowflake Semantic View named sales_model.

Frequently Asked Questions about import_powerbi

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

FAQPage Schema
How do I import a Power BI file into Snowflake Semantic Views?▼

Upload the .pbit or .pbix file to a Snowflake stage, run the pbi_analyze tool to inspect its tables and measures, then execute pbi_export_yaml.py with the file path, model name, and output file to generate the Semantic View YAML.

What is the difference between .pbit and .pbix import?▼

Both formats are accepted and auto-detected by ZIP contents. .pbix files require VertiPaq XPress9 decompression, so they take longer to process and need longer timeouts compared to .pbit template files.

Can I filter which Power BI tables and measures get imported?▼

Yes, use --include-tables, --include-columns, and --include-measures with exact case-sensitive names from the analyze output. Note that --no-measures is a separate kill-switch that drops all DAX measures entirely.

Why are some DAX measures missing after Power BI import?▼

DAX measures that cannot be transpiled to SQL are silently dropped and counted in unsupported_measure_count. You can recreate them manually as SQL metrics in the exported YAML file.

How do I fix table validation errors when importing from another environment?▼

Re-export with --target-database and --target-schema to remap where the data lives, and add --skip-table-validation to bypass the pre-build validation when source tables do not exist locally.

Related Skills

Explore More Data & Analytics Skills→
wardawgmalviciouswardawgmalvicious
2

pbip-project-structure

Manage Power BI project folder layouts, entry-point files, and PBIX conversion.

Community
Intermediate
QuilpieQuilpie
2

snowflake-amazon-quick-skills

Automate Snowflake Cortex AI and Amazon QuickSight integration for sales analytics pipelines.

Community
Advanced
NzettodessNzettodess

powerbi-modeling

Builds and optimizes Power BI semantic models with DAX measures, relationships, and RLS.

Community
Advanced
sigmacomputingsigmacomputing
6

tableau-to-sigma

Automates migration of Tableau workbooks and datasources to Sigma Computing with parity validation gates.

Official
Advanced