How to get the DAX query behind PowerBI visualizations?

[iluvaccounting1]

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!

[Daniel29195 · Accepted solution]

@iluvaccounting1 

try the following : 
open dax studio

connect 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! 🙏

[Anonymous · Accepted solution]

HI @iluvaccounting1,

I'd like to suggest you try to use power bi desktop, it can also trace the visual backend processing queries.

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

Regards,

Xiaoxin Sheng

[Daniel29195 · Accepted solution]

@iluvaccounting1 

try the following : 
open dax studio

connect 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! 🙏