Idea: Introducing Excel-Style Table in Power BI
One of the most requested enhancements from business users is the ability to view and interact with data in a familiar, Excel-style table directly within Power BI. While Power BI offers powerful visuals like Matrix and Table, users often seek the look, feel, and interactivity of Excel — including easy column resizing, inline filtering, cell-based formatting, and copy/paste support.
Concept
An Excel-style Table visual would provide:
Native grid layout with cell-level formatting (font color, borders, background, alignment).
Inline filtering, sorting, and quick calculations (sum, average, count) just like Excel.
Support for column freeze, search, and conditional formatting per cell.
One-click export to Excel retaining table styling.
Optional formula bar view for exploring measure logic or calculations.
Why It Matters
This feature would bridge the gap between data analysis and presentation, helping users who rely on Excel for detailed tabular exploration feel more at home in Power BI. It also supports print-ready layouts, making it ideal for governance reports, audit views, and compliance dashboards.
Potential Impact
By integrating an Excel-like table experience, Power BI can become the single workspace for both analytical depth and reporting convenience, reducing the need to export data and improving collaboration within Fabric.
on:
Introducing Excel-Style Table in Power BI
frithjof_v
on:
Role Based Access Control for Variable Libraries
YSD
on:
Add Dataverse as a Real-Time Data Source
on:
CREATE a FUNCTION that allows to extract the exact...