Power BI to Databricks Semantic Layer Generator (DAX → SQL/PySpark)

marvin-alpura — Thu, 10 Apr 2025 21:21:10 GMT

Hi everyone!

I’ve just released an open-source tool that generates a semantic layer in Databricks notebooks from a Power BI dataset using the Power BI REST API. Im not an expert yet, but it gets job done and instead of using AtScale/dbt/or the PBI Semantic layer, I make it happen in a notebook that gets created as the semantic layer, and could be used to materialize in a view.

It extracts:

Tables
Relationships
DAX Measures

And generates a Databricks notebook with:

SQL views (base + enriched with joins)
Auto-translated DAX measures to SQL or PySpark (e.g. CALCULATE, DIVIDE, DISTINCTCOUNT)
Optional materialization as Delta Tables
Documentation and editable blocks for custom business rules

🔗 GitHub: https://github.com/mexmarv/powerbi-databricks-semantic-gen

Example use case:

If you maintain business logic in Power BI but need to operationalize it in the lakehouse — this gives you a way to translate and scale that logic to PySpark-based data products.

It’s ideal for bridging the gap between BI tools and engineering workflows.

I’d love your feedback or ideas for collaboration!

..: Please, again this is helping the community, so feel free to contribute and modify to make it better, if it helps anyone out there ... you can always honor me a "mexican wine bottle" if this helps in anyway :..

PS: Some spanish in there, perdón... and a little help from "el chato: ChatGPT".

- Marvin

Re: Power BI to Databricks Semantic Layer Generator (DAX → SQL/PySpark)

Anonymous — Fri, 11 Apr 2025 14:18:01 GMT

Hi @marvin-alpura,

Just wanted to say a big thank you for sharing this tool with the community! 🙌
please consider this reply as "Accept as Solution" and click on "Yes" so that other community members will find it more quickly.

Please continue using Microsoft community forum.

Regards,

Vinay Pabbu

topic Re: Power BI to Databricks Semantic Layer Generator (DAX → SQL/PySpark) in Developer

Power BI to Databricks Semantic Layer Generator (DAX → SQL/PySpark)

Re: Power BI to Databricks Semantic Layer Generator (DAX → SQL/PySpark)