MS Excel table within Power BI

Hi Anjan_Madhwesh 

Currently, table and matrix visuals in Power BI lack the flexibility and interactivity that users are accustomed to in Microsoft Excel, particularly when working with tabular data. While Power BI excels at handling and visualizing large volumes of data efficiently, its table-like visuals are not as user-friendly or dynamic. Many users express the need for Excel-like features such as auto-filtering directly on column headers, allowing them to quickly search and filter values without relying on separate filter panes or slicers—which can feel clunky and disrupt the flow of analysis. Additionally, a common request is for a feature similar to Excel’s VLOOKUP, where users could directly cross-reference values across tables in a more intuitive and interactive manner, rather than relying on pre-built DAX measures or complex relationships. Introducing these familiar capabilities into Power BI would significantly improve usability for business users, especially those transitioning from Excel, and make the platform more powerful for ad hoc exploration and analysis.