Forum Discussion

Luci7's avatar
Luci7
Helper I
3 years ago

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

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.

data engineering

2 Replies

  • HimanshuS-msft's avatar
    HimanshuS-msft
    Microsoft Employee
    3 years ago

    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's avatar
      Luci7
      Helper I
      3 years ago

      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