Forum Discussion
How to get the DAX query behind PowerBI visualizations?
I need to get the DAX query behind the PowerBI visualization. I know that it is possible to do by using performance analyzer, re-running the query and then getting the underlying DAX coding from that. The issue I am running into is that the PowerBI I'm working with doesn't have access to the dataset which was originally queried in so if I try to refresh the queiries the model errors out.
Any work arounds / help would be greatly appreciated.
Thanks!
try the following :
open dax studioconnect it to your local power bi file. ..
at the top enable : all queries .
now any interaction with the power bi file, the query of the visuals will be listed below .
let me know if this works .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏HI iluvaccounting1,
I'd like to suggest you try to use power bi desktop, it can also trace the visual backend processing queries.
Regards,
Xiaoxin Sheng
2 Replies
- Daniel29195
Community Champion
try the following :
open dax studioconnect it to your local power bi file. ..
at the top enable : all queries .
now any interaction with the power bi file, the query of the visuals will be listed below .
let me know if this works .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏 HI iluvaccounting1,
I'd like to suggest you try to use power bi desktop, it can also trace the visual backend processing queries.
Regards,
Xiaoxin Sheng