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