topic Re: Show SQL from visual query not possible in Data Engineering

Show SQL from visual query not possible

Artefact — Sun, 29 Oct 2023 23:38:06 GMT

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

Re: Show SQL from visual query not possible

AndyDDC — Mon, 30 Oct 2023 09:29:49 GMT

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

Re: Show SQL from visual query not possible

Artefact — Mon, 30 Oct 2023 10:15:33 GMT

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.

Re: Show SQL from visual query not possible

Artefact — Mon, 30 Oct 2023 10:21:23 GMT

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

Re: Show SQL from visual query not possible

v-cboorla-msft — Mon, 30 Oct 2023 11:44:41 GMT

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.