Microsoft Fabric | Power BI | Data Analytics & AI

DAX Parser App

Parse DAX using PyDAX in an app

UpdatedNovember 2, 2024

Principal Program Manager, Microsoft Fabric CAT helping users and organizations build scalable, insightful, secure solutions. Blogs, opinions are my own and do not represent my employer.

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

RAG in Fabric Notebook Using Microsoft Harrier Multilingual Text Embedding Model

Last week Microsoft released an open-source text embedding model called Harrier in three sizes- 270M, 0.6B and 27B. I have been testing it in my RAG pipeline and so far it has crushed all my metrics.

Apr 14, 2026

Programmatically Retrieve Prep Data For AI Configuration of Semantic Models

For Power BI Copilot and Data agents with semantic models, you must use Prep Data for AI configuration to ground the responses in the context added in Prep for AI. In this blog, I will show you how yo

Apr 2, 2026

Cross-referencing Notebooks In The Updated Fabric Notebook Copilot

At FabCon Atlanta last week, the updated notebook Copilot for data engineering and data science was announced. It brings agentic capabilities to the Copilot and is much more intelligent and Fabric-awa

Mar 24, 2026

Programmatically Comparing Draft vs Production Fabric Data Agent Responses

Using Fabric data agent Python SDK

Jan 16, 2026

Monitoring Power BI Modeling MCP Server Usage and Adoption

Use workspace monitoring to monitor MCP server use

Dec 14, 2025

M

Microsoft Fabric | Power BI | Data Analytics & AI

119 posts

Hi 👋I am Sandeep Pawar, data and AI professional. As a Principal Program Manager @Microsoft Fabric CAT, I help users and customers succeed with Microsoft Fabric.

The power of open-source and GenAI. Klaus Jürgen Folz recently open-sourced the PyDAX library, which parses DAX expressions to extract or remove comments, and identify referenced columns and measures. I used that library to create some demos for myself and then shared the notebook along with instructions with Replit agents to build an app for me.. 15 minutes & 3 prompts later I had a fully functional app. Give it a try : https://daxparser.replit.app/

💡

I have provisioned a bare minimum VM to run the app so be patient and gentle with it :P It will likely be slow.

Notes:

Daniel Otykier, author of Tabular Editor, mentioned that technically it’s a lexer and not a parser and has limitations. Also, PyDAX is based on the lexer Daniel open-sourced with TE2.
I tried Replit a couple of months ago, and it was slow and buggy. It has definitely improved a lot. It's better at following instructions, resolving issues, and not getting stuck.
The app is built on Streamlit.
There are still some bugs, but my goal wasn't to make it perfect. I might take it down and use it locally. If I do, I will share the code for others to use.
I am using PyDAX as is, and I have not tested it, so please exercise your judgement.
It doesn’t format DAX. Use DAX formatter or my notebook for that.

#dax-parser #dax #replit-agent

Command Palette

Comments

More from this blog

Notes: