Excel Online has introduced a groundbreaking feature that significantly enhances data handling and analysis capabilities for users: the ability to create connected tables using data from Power BI semantic models. This update brings a new level of integration and efficiency, allowing users to directly connect to and work with data in a more interactive and dynamic manner.
The process of creating connected tables is designed to be straightforward and user-friendly. By navigating to the Data tab and selecting the desired data from Power BI, users can easily insert and customize their tables within Excel Online. This includes selecting specific data to display, applying filters to refine the information, and rearranging fields to suit their analysis needs.
This enhancement is not restricted to Excel Online; it is progressively being made available for the Excel desktop application across various Microsoft 365 update channels. With a full rollout expected by July 2024, this feature is set to benefit a wide range of users by facilitating a seamless data experience. Microsoft encourages users to explore this new connected tables experience and provide feedback to help refine and improve the offering.
Excel Online connected tables, connected tables in Excel Online, Excel Online new features, creating connected tables Excel, Excel Online update, connected data tables Excel Online, Excel collaboration tools, Excel Online enhancements