In the "Queries" section in the lakehouse, you can make visual queries or SQL queries.
The visual query does not have any "save as table" or "save as view" option, where a SQL query has.
One way to save the result of the visual query as table/view is copy the SQL statement ("view SQL"), copy it to a SQL query, run and save that result as table/view.
So, can you add the functionality to save the result of the visual query directly.
(Also, why do we need to select a part of the SQL statement, why can we not save the whole result of the query as a table?)
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels2 hours agoAdvocate IIINew177Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen3 hours agoAdvocate INew292Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi3 hours agoMicrosoft EmployeeNew17Views6likes0Comments