DAX Parser App

Sandeep PawarSandeep Pawar
2 min read

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.

0
Subscribe to my newsletter

Read articles from Sandeep Pawar directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Sandeep Pawar
Sandeep Pawar

Microsoft MVP with expertise in data analytics, data science and generative AI using Microsoft data platform.