Save a Visual Query results as a Table in Lakehouse SQL endpoint

[Luci7]

Hi all,

Working on MS Fabric, in the Lakehouse SQL endpoint, I created a Visual Query:

in this visual query, I am appending two tables. Is it possible to save the results as a Table? I tried everything and I cannot because this option is not available. I can only see "Download or Visualize".

I can only save the results as a table, if I write a SQL query because it gives me this option:

Thank you very much for any assistance you could provide.

Best regards.

[HimanshuS-msft]

Hello @Luci7 , 

Thanks for using the Fabric community .

I dont think you can do that , but you can use the "View SQL" Option the Visual Query and then paste the query in the "New SQL query " .

Thanks
HImansh

[Luci7]

Hello @HimanshuS-msft and thank you for your help. I tried to do as you said, but when you append data_table and data_table (2) in your example, the "view SQL" only shows, for me, the SQL query of one table and not the new created appended table. Could you kindly see if you are able to reproduce this issue? 

Thank you very much!

Kind regards,

Luci