Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
charlieclarke
New Member

View SQL Syntax

Hello

Newbie here

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

Many Thanks

Charlie

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

@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 ) >

Daniel29195_0-1709487119679.png

 

 

 

copy the code from here ;  using copy query,

Daniel29195_1-1709487178413.png

 

 

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

Daniel29195_2-1709487245027.png

 

 

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

 

Daniel29195_3-1709487375464.png

 

 

 

 

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

 

View solution in original post

1 REPLY 1
Daniel29195
Super User
Super User

@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 ) >

Daniel29195_0-1709487119679.png

 

 

 

copy the code from here ;  using copy query,

Daniel29195_1-1709487178413.png

 

 

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

Daniel29195_2-1709487245027.png

 

 

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

 

Daniel29195_3-1709487375464.png

 

 

 

 

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

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors