Skip to content

Instantly share code, notes, and snippets.

@Curts0

Curts0/pytabularqueries.py

Created September 22, 2022 23:08
Show Gist options
  • Save Curts0/6bf28a9565495bb925702304b6271f6e to your computer and use it in GitHub Desktop.
Save Curts0/6bf28a9565495bb925702304b6271f6e to your computer and use it in GitHub Desktop.
Download ZIP
PyTabular Queries
Raw
pytabularqueries.py
#Run basic queries
DAX_QUERY = "EVALUATE TOPN(100, 'Table1')"
model.Query(DAX_QUERY) #returns pd.DataFrame()
#or...
DMV_QUERY = "select * from $SYSTEM.DISCOVER_TRACE_EVENT_CATEGORIES"
model.Query(DMV_QUERY) #returns pd.DataFrame()
#or...
SINGLE_VALUE_QUERY_EX = "EVALUATE {1}"
model.Query(SINGLE_VALUE_QUERY_EX) #returns 1
#or...
FILE_PATH = 'C:\\FILEPATHEXAMPLE\\file.dax' #or file.txt
model.Query(FILE_PATH) #Will return same logic as above, single values if possible else will return pd.DataFrame()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment