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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Artefact
Helper II
Helper II

Show SQL from visual query not possible

When I set up a visual query in the lakehouse sql-endpoint and choose "show sql", only the a select statement from the 1st table is shown. All applied steps are missing. consequently, also save as view doesn't make sense.

Any suggestions why teh SQL code is not showing? thanks

1 ACCEPTED SOLUTION
Artefact
Helper II
Helper II

found it! You have to turn on "enable load" for each step first to use the 2 buttons "show sql" and "save as view"....


View solution in original post

4 REPLIES 4
Artefact
Helper II
Helper II

found it! You have to turn on "enable load" for each step first to use the 2 buttons "show sql" and "save as view"....


Hi @Artefact 

 

Thanks for using Fabric Community.

Glad to know that your issue got resolved. Please continue using Fabric Community for help regarding your issues.

AndyDDC
Solution Sage
Solution Sage

Hi @Artefact, you should be able to see the SQL for the applied steps if you click the button in the top right of the visual query window to bring up the power query window.  Then select the step in the visual window you want to see the sql for, then right-click the relevant applied step on the right-hand side and select View Data Source Query

 

AndyDDC_0-1698658042335.png

 

 

AndyDDC_1-1698658051944.png

 

AndyDDC_2-1698658123704.png

 

 

Hello Andy,

Thank for your post. Now I see that you can show the query if you select the last step in the visual query (you can also do that in the mail screen of the visual quey without opening a separate PQ window)
But still, I've seen demo's where you just click the button "Show SQL" in the menu bar for the same result. And the save as view button just makes it possible to automaticaly make a view. Now I have still to copy and paste the SQL and manually add the "save view as" code. But fo now I can use the other method. Thanks again.

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.