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
Allow Downloading Power Query (M) Transformations Along with Power BI Reports from the Service
Category: Power BI Service / Data Connectivity Description: Hi Power BI Community Team, I would like to suggest a feature enhancement for Power BI Service that would be useful for Power BI develop...Manogna89192 hours agoRegular VisitorNew3Views0likes0CommentsAllow Admin Recovery of Orphaned Cloud Gateway Connections
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Problem When a cloud gateway connection has no active owner (for exampl...RohiniUppu3 hours agoMicrosoft EmployeeNew2Views0likes0CommentsAdd support for identity columns in Fabric warehouses.
Identity columns are a common method for generating surrogate keys in data warehousing scenarios implemented on SQL Server. By adding support for identity columns in Fabric, users could migrate the...dpurdy10 hours agoRegular VisitorCompleted4.4KViews131likes11CommentsFabric UX Idea: Clearly Identify the Source Workspace for Opened Fabric Artifacts
In many Fabric implementations, organizations have multiple projects and environments, for example: Sales Analytics – Development Sales Analytics – UAT Sales Analytics – Production Similarl...Murtaza_Ghafoor16 hours agoSuper UserNew9Views0likes0CommentsCopilot in Power BI should be canvas-aware and support screenshots / direct visual debugging.
Currently, Copilot in Power BI cannot: See the actual canvas / selected visual Accept screenshots or images to aid in troubleshooting Both of these make debugging visual-level issues painful and...dcohare16 hours agoHelper INew12Views1like0Comments