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

[BenBlackswan]

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.

[BenBlackswan]

THank you! I have marked your reply as solution.

[suparnababu8 · Accepted solution]

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!