SQL queries in a Fabric Warehouse, Lakehouse, etc. save automatically with a generic name, e.g. SQL query 1.
While there have been improvements to allow for bulk deleting, I would suggest adding the following functionality:
- Allow users to choose between automatically saving new queries (as it works now) or automatically deleting any unsaved queries after they're closed.
- A quick button to 'delete unnamed queries', which would leave any queries which have been renamed or saved with an actual name, deleting any which have just been saved with the generic 'SQL query 1' type name.
- Allow users to select a retention period and automatically delete unnamed queries after this time, e.g. after 1 day / 1 week.
1 Comment
rashadnMicrosoft Employee
Hi OMackenzie,
We’ve added the ability to turn off AutoSave for SQL queries. You can disable it by clicking the AutoSave status in the footer and selecting Turn off.
With AutoSave disabled, changes won’t be saved automatically, which should help reduce the accumulation of queries you don’t want to keep.
I hope this helps address your scenario!
Recent ideas
Allow setting default scroll position in Table and Matrix visuals (e.g., start from rightmost column
Currently, Power BI Table and Matrix visuals always open scrolled to the leftmost column by default, which is inconvenient for reports where the most important data is on the right side. Please add ...
