Improve Power Query UI: Move Query Settings Pane & Expand Workspace for Better Data Visibility
Feature Request: Two UI enhancements to improve readability and workspace in Power Query
While working with medium to large datasets in Power Query, the available screen space becomes very limited, especially when dealing with many columns. I would like to propose two UI improvements that will give users more control and make data transformation easier and more comfortable.
1. Option to Move/Shift the Query Settings Pane to the Left Side (or Dock Anywhere)
The Query Settings pane currently appears fixed on the right side.
When working on smaller screens or with wide tables, the right-side pane occupies valuable horizontal space.
Suggested Enhancement:
Allow users to dock the Query Settings pane on the left side, similar to how the Queries pane is docked.
Even better, allow a drag-and-drop, customizable docking system (left, right, bottom, or floating window).
This will help users who prefer to keep important panes together and free up more room for the data preview.
Benefits:
More intuitive layout (Queries + Query Settings on the same side).
Less horizontal scroll when working with wide datasets.
Improved ergonomics and workflow efficiency.
2. Provide a “Maximize Data Preview” or “Full-Width Table View” Mode
When working with many columns, the data preview area becomes too narrow.
Suggested Enhancement:
Add an option such as “Maximize Data Preview”, which temporarily hides:
Queries pane
Query Settings pane
Ribbon (optional toggle)
Or provide a single-click “Expand Table View” button that gives more horizontal reading space.
Benefits:
Cleaner, distraction-free data view.
Easier to inspect, clean, and transform wide tables.
Reduces excessive horizontal scrolling.
Greatly improves usability on laptops and smaller monitors.
Why This Matters
Both enhancements will significantly help analysts and developers who:
Work with datasets having 20+ columns
Build complex transformations
Use Power Query daily in Power BI, Excel, or Fabric
These changes will improve productivity, reduce frustration, and enhance the overall user experience.
Recent ideas
:: operator for typecast in T-SQL
Introduce support for the ::type cast operator in Fabric Data Warehouse as syntactic sugar for the existing CAST(... AS type) expression. The new operator would be functionally equivalent and compile...jovanpop-msft2 hours agoMicrosoft EmployeeNew8Views0likes0CommentsNative Multi-Visual Cascading Selection (Beyond Ctrl + Click)
The Problem: When working with multiple tables or matrices on a report page, users frequently need to chain selections together (e.g., clicking Matrix A filters Matrix B, and then clicking Matrix B ...7407546 hours agoNew MemberNew12Views0likes1CommentPipeline activity Refresh SQL Endpoint (preview) does not accept dynamic content
I am testing out the new Pipeline activity for Refresh SQL Endpoint, currently in preview. Sure, I get it that this is in preview, but it should at least have basic minimum functionality. It do...ToddChitt6 hours agoSuper UserNew569Views7likes5CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf6 hours agoFrequent VisitorNew30Views1like1CommentSupport Git-Integrated Files in Fabric Workspaces
Overview Allow users to store and manage arbitrary files such as .md, .sql, .py, and .yml directly in a Fabric workspace, with built-in Git integration. Value This would keep documentation, SQL sc...ryomaru08257 hours agoAdvocate INew9Views0likes0Comments