New Get Data dialog and OneLake catalog in Excel for Windows



 Microsoft 365 Insider Blog:

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.

    bS00NDMwODc4LWl6dE1LNw

  3. Browse through popular data sources on the Home tab, or use the search bar to find a specific source.
    The Choose data source menu in Get Data in Microsoft Excel for Windows.


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

    bS00NDMwODc4LWJuU2V2Rg

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

    bS00NDMwODc4LUl4UlBTTw


    bS00NDMwODc4LUptVW9ucQ

  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.


 Source:

techcommunity.microsoft.com

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

The new Get Data dialog and OneLake catalog for Power Query in Microsoft Excel for Windows brings together search and recommendations in a streamlined layout...
techcommunity.microsoft.com techcommunity.microsoft.com
 
Click to expand...
That’s pretty handy
 

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2 Build 22631.5624
    Computer type
    PC/Desktop
    Manufacturer/Model
    Sin-built
    CPU
    Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz (4th Gen?)
    Motherboard
    ASUS ROG Maximus VI Formula
    Memory
    32.0 GB of I forget and the box is in storage.
    Graphics Card(s)
    Gigabyte nVidia GeForce GTX 1660 Super OC 6GB
    Sound Card
    Onboard
    Monitor(s) Displays
    5 x LG 25MS500-B - 1 x 24MK430H-B - 1 x Wacom Pro 22" Tablet
    Screen Resolution
    All over the place
    Hard Drives
    Too many to list.
    OS on Samsung 1TB 870 QVO SATA
    PSU
    Silverstone 1500
    Case
    NZXT Phantom 820 Full-Tower Case
    Cooling
    Noctua NH-D15 Elite Class Dual Tower CPU Cooler / 6 x EziDIY 120mm / 2 x Corsair 140mm somethings / 1 x 140mm Thermaltake something / 2 x 200mm Corsair.
    Keyboard
    Corsair K95 / Logitech diNovo Edge Wireless
    Mouse
    Logitech: G402 / G502 / Mx Masters / MX Air Cordless
    Internet Speed
    1000/400Mbps
    Browser
    All sorts
    Antivirus
    Kaspersky Premium
    Other Info
    I’m on a horse.
  • Operating System
    Windows 11 Pro 23H2 Build: 22631.4249
    Computer type
    Laptop
    Manufacturer/Model
    LENOVO Yoga 7i EVO OLED 14" Touchscreen i5 12 Core 16GB/512GB
    CPU
    Intel Core 12th Gen i5-1240P Processor (1.7 - 4.4GHz)
    Memory
    16GB LPDDR5 RAM
    Graphics card(s)
    Intel Iris Xe Graphics Processor
    Sound Card
    Optimized with Dolby Atmos®
    Screen Resolution
    QHD 2880 x 1800 OLED
    Hard Drives
    M.2 512GB
    Antivirus
    Defender / Malwarebytes
    Other Info
    …still on a horse.
You must log in or register to reply here.

Similar threads

  • Article Article
What is New in Excel for June 2025
Replies
0
Views
224
Brink
Brink
  • Article Article
What is New in Excel for May 2025
Replies
0
Views
287
Brink
Brink
  • Article Article
Excel for Windows now supports Dark Mode to reduce eye strain
Replies
2
Views
854
HuntyFtw
HuntyFtw
  • Article Article
Stale value formatting now available in Excel for Windows
Replies
0
Views
223
Brink
Brink
  • Article Article
What is New in Excel for April 2025
Replies
3
Views
2K
TraderGary
TraderGary

Latest Support Threads

Latest Tutorials

Back
Top Bottom