Forum Discussion

BenBlackswan's avatar
BenBlackswan
Icon for Helper V rankHelper V
1 year ago
Solved

Why I do not have "Save as Table" button in my Query Explorer?

hello all.

 

In the Fabric DWH documentation says that I can Save a Table with a button (which is located between the Results tab and before "Open in Excel".

 

However in my Query Explorer, I do not have this button. I am using Trial licence for my Fabric at the moment if this matters.

 

 

workspaces
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    Hi BenBlackswan 

     

    It's not about Trail license. You are using Lakehouse SQL analytics endpoint. In this you won't see the option called Save as table becuase primarily supports read operations and it is optimized for data lake storage rather than traditional transactional processing. pls refer below image. 

     

     

    If you want to save your query/result as table you can use data Warehouse. In Warehouse you will get the option "save as table" . Please refere below image of warehouse query. 

    If you want save your query as a tbale, select your query in the explorer and now click on save as table.

    Once you click save as table option now you will see this window. give proper name ans clisk on save

    Now your result will be saved automatically as a table.

     

    Hope you are clear now.

     

    Thank you!

     

    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!

     

     

     

2 Replies

  • suparnababu8's avatar
    suparnababu8
    Icon for Super User rankSuper User
    1 year ago

    Hi BenBlackswan 

     

    It's not about Trail license. You are using Lakehouse SQL analytics endpoint. In this you won't see the option called Save as table becuase primarily supports read operations and it is optimized for data lake storage rather than traditional transactional processing. pls refer below image. 

     

     

    If you want to save your query/result as table you can use data Warehouse. In Warehouse you will get the option "save as table" . Please refere below image of warehouse query. 

    If you want save your query as a tbale, select your query in the explorer and now click on save as table.

    Once you click save as table option now you will see this window. give proper name ans clisk on save

    Now your result will be saved automatically as a table.

     

    Hope you are clear now.

     

    Thank you!

     

    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!