View SQL Syntax

[charlieclarke]

Hello

Newbie here

I would like to know how to view the SQL syntax behind a power bi visual specifically joins.

Many Thanks

Charlie

[Daniel29195 · Accepted solution]

@charlieclarke 

you can see tge psudo sql code : 

download dax studio . 

open dax studio

connect to your power bi file ( make sure that your file is open on the pc ) .

go to performance analyser . 

and click on the visual you want to inspect its sql code.  ( click on 2 ) >

copy the code from here ;  using copy query,

paste it into dax studio .  ( be sure to click on server timings and query plan ) and then run the query in dax studio,

you will have the sql code in the server timings paanel .

let me know if this helps. 

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! 🤠