skills.rest
bcastelino
bcastelinoCOMMUNITY
Explore all skills by this author →
Website𝕏@cas7elinoGitHub

query-to-pbip

Convert Databricks Genie SQL or YAML metric views into Power BI Desktop Projects.

1|Updated May 13, 2026
Search Tags:#data conversion#power bi#pbip#databricks genie#sql to tmdl
One-click install
npx skills add https://github.com/bcastelino/powerbi-dashboard-generator --skill query-to-pbip
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-to-pbip
Source: https://github.com/bcastelino/powerbi-dashboard-generator/tree/main/skills/query-to-pbip
Command: npx skills add https://github.com/bcastelino/powerbi-dashboard-generator --skill query-to-pbip

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, sqlalchemy, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the process of converting Databricks Genie Queries into fully functional Power BI Desktop Projects, eliminating the need for manual modeling, DAX, or visual configuration.

Core Features & Use Cases

  • Query to PBIP Conversion: Converts Genie SQL or YAML metric views into a complete Power BI Desktop Project (PBIP).
  • Semantic Model & Visuals: Generates a semantic model (TMDL) and report visuals (PBIR) based on the query.
  • Use Case: If you have a Genie SQL query or YAML metric view, use this skill to automatically generate a Power BI Desktop Project containing a semantic model and report visuals.

Quick Start

Use the query-to-pbip skill to convert the Genie SQL query from 'sales-query.sql' to a Power BI Desktop Project.

Frequently Asked Questions about query-to-pbip

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

FAQPage Schema
How do I convert Databricks Genie SQL queries to a Power BI Desktop Project?▼

To convert Databricks Genie SQL queries to a Power BI Desktop Project, use an automated conversion process that generates a TMDL semantic model and PBIR report visuals directly from the query.

Can I generate Power BI visuals automatically from YAML metric views?▼

Yes, YAML metric views can be automatically converted into Power BI Desktop Projects. The process handles visual type selection and PBIP packaging to produce a complete semantic model and report.

Do I need Python to convert SQL to TMDL for Power BI?▼

Yes, Python is required for scripting and executing the conversion of SQL to TMDL models. The process relies on Python dependencies like pandas, numpy, and sqlalchemy to build the PBIP output.

What is the best way to automate Power BI report creation from Databricks queries?▼

The best way to automate Power BI report creation from Databricks queries is to use a conversion tool that translates Genie SQL into TMDL models and packages them into a functional PBIP format.

Does converting SQL to TMDL handle visual type selection automatically?▼

Yes, converting SQL to TMDL handles visual type selection automatically. It generates both the semantic model and the appropriate report visuals to create a fully functional Power BI Desktop Project.

What are the limitations of converting Genie SQL to PBIP format?▼

Limitations of converting Genie SQL to PBIP format include the strict requirement of a Python environment for execution and dependency on specific libraries like pandas and sqlalchemy for query processing.

Related Skills

Explore More Data & Analytics Skills→
datasciencemonkeydatasciencemonkey
27

databricks-metric-views

Define reusable business metrics in YAML for Unity Catalog metric views.

Community
Advanced
k-sandhuk-sandhu

agent-skill-power-bi-dashboard

Automate creation, validation, and packaging of Power BI projects.

Community
Advanced
exploreomniexploreomni
30

omni-to-databricks-metric-view

Convert Omni topic metrics into Databricks Metric View YAML definitions for Unity Catalog.

Official
Advanced
bcastelinobcastelino

semantic-mapper

Translate data model descriptions into Power BI TMDL semantic models.

Community
Advanced