Forum Discussion
Visualisation query on imported database
Hi Anonymous,
aha, I see.
Do you know the DAX Studio (https://daxstudio.org/)?
It can visualize how a DAX query is evaluated: https://daxstudio.org/documentation/features/query-plan-trace/
EDIT:
And a link on Youtube how to trace a DAX query: https://www.youtube.com/watch?v=fAwvJa3Xkso
Hi Nolock thanks for your reply!
First of all, you are absolutely right! I've found this feature myself earlier, but it's not really what I meant.
You see, query folding occurs when I edit my query in Power Query, not when I create or filter a visualisation in my report.
I've imported a MySQL database into my report, which means it's not sending any query's back to my database after I apply the query's in Power Query. (Apart from refreshing my data of course, which only repeats the Power Queries).
I'm kind of looking for the "view native query" functionality at my report visuals or any other way to find out what's happening in the background.
Do you see what I mean?
~ Wessel
Hi Anonymous,
aha, I see.
Do you know the DAX Studio (https://daxstudio.org/)?
It can visualize how a DAX query is evaluated: https://daxstudio.org/documentation/features/query-plan-trace/
EDIT:
And a link on Youtube how to trace a DAX query: https://www.youtube.com/watch?v=fAwvJa3Xkso
This is exactly what I needed!
It helped me to understand how DAX is applied on querying results. Unfortunately DAX is not open-source, so I can't really discover how these functions actually operate.