Skip to main content
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

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

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

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.

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










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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

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