DAX Parser App
Parse DAX using PyDAX in an app
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/
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.