AzureFeeds

Hi, Microsoft 365 Insiders! My name is Gal Zivoni, and I’m a Product Manager on the Excel team. I’m excited to share a new, modern experience for Power Query in Microsoft Excel for Windows that also introduces the OneLake catalog.

Introducing the new Get Data dialog and OneLake catalog in Excel for Windows

We’re introducing a new way to connect to data in Microsoft Excel for Windows that will make finding and using external data sources faster, smarter, and more intuitive! The new Get Data dialog for Power Query brings together search and recommendations in a streamlined layout to help you quickly locate the right data source to bring data from. The new experience also gives you access to all the high-quality data from across your organization that’s stored in Fabric’s OneLake right within Excel.

How it works

1. Open Excel on your Windows device and sign into your Microsoft 365 account.


2. Select the Data tab on the ribbon, then select Get Data > Get Data (Preview) to open the new dialog.

3. Browse through popular data sources on the Home tab, or use the search bar to find a specific source.

NOTE: To browse through all available data sources, select the New tab under the categories list on the left.

4. To browse through OneLake data artifacts, navigate to the OneLake catalog section in the Home tab, or the OneLake tab on the left.
   

    

   
   

5. Select your desired data source and follow the prompts to import the data into Excel as you normally would before this update.

Tips and tricks

• You can still import external data from the Get Data dropdown categories as well as from the new Get Data dialog.


• Lakehouse and Warehouse are currently supported in the OneLake catalog, with more data source support coming soon!


• For more information, check out About Power Query in Excel.

Availability

This feature is available to Beta Channel users running Version 2505 (Build 18829.20000) or later in Excel for Windows.

Feedback

We want to hear from you! Please submit your comments and feedback on this new feature by selecting Help > Feedback in Excel.  

Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!