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

Ready to run

npx skills add https://github.com/bcastelino/powerbi-dashboard-generator --skill query-to-pbip

💬 Prompt for ChatGPT / Claude Chat▼

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.