Excel Online Launches Innovative Connected Tables Feature

Key insights

• Excel Online now supports creating tables using data from Power BI semantic models, making this feature available to everyone.
• Users can directly connect to data in their semantic model by selecting Data from Power BI on the Data tab, facilitating seamless data integration.
• The process includes selecting data, applying filters, and rearranging the field order, which culminates in inserting a table connected to the Power BI semantic model.
• The connected tables feature is also being rolled out to the Excel desktop application across Microsoft 365 update channels, with full availability expected by July 2024.
• Users are encouraged to learn more about the connected tables experience and share their feedback or ideas on the Microsoft Fabric ideas forum.

Exploring Excel Online's New Feature: Connected Tables

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.

Read the full article Announcing the creation of connected tables in Excel Online

Keywords

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