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 My Computers

System One System Two Other systems

  • At a glance

    Windows 11 Pro 25H2 Build 26200.9168Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz32.0 GB of I forget and the box is in storage.Gigabyte nVidia GeForce GTX 1660 Super OC 6GB
    OS
    Windows 11 Pro 25H2 Build 26200.9168
    Computer type
    PC/Desktop
    Manufacturer/Model
    Sin-built 2013
    CPU
    Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz
    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
    ROG SupremeFX Formula 8-Channel High Definition Audio
    Monitor(s) Displays
    5 x LG 25MS500-B - 1 x 24MK430H-B - 1 x Wacom Pro 22" Touch Screen 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
    2000/500Mbps
    Browser
    All sorts
    Antivirus
    Kaspersky Premium
    Other Info
    ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
    TP-Link BE9300 WiFi 7 Bluetooth 5.4 (Archer TBE550E)
    TP-Link TX201 V1 2.5GB Lan

    Grandstream HT812 - VoIP
    ASUS DSL-AX82U - Mesh
    ASUS RT-AC68U - Mesh
    ASUS RT-BE88U Router

    Brother MFC-L2880DW Printer

    I’m on a horse.

  • At a glance

    Windows 11 Pro 25H2 Build 26200.9168 (Wifes)13th Generation Intel® Core™ i5-1340P Process...16GB LPDDR5-52001x Intel® Iris® Xe Graphics
    Operating System
    Windows 11 Pro 25H2 Build 26200.9168 (Wifes)
    Computer type
    Laptop
    Manufacturer/Model
    LENOVO Yoga 7 14IRL8 - Type 82YL
    CPU
    13th Generation Intel® Core™ i5-1340P Processor(Core™ i5-1340P)
    Memory
    16GB LPDDR5-5200
    Graphics card(s)
    1x Intel® Iris® Xe Graphics
    Sound Card
    Optimized with Dolby Atmos®
    Screen Resolution
    QHD 2880 x 1800 OLED
    Hard Drives
    M.2 512 GB SSD PCIe
    Mouse
    Logiteck MX Master 3S
    Internet Speed
    2000/500
    Antivirus
    Defender / Malwarebytes
    Other Info
    …still on a horse.


    Wireless Network: Wi-Fi 6E 2x2 AX; Bluetooth® 5.1 or above
    Ports: 1x 1 Novo button; 2 in 1 Audio Combo jack; Micro SD Card Reader; HDMI 1.4b; 2 x USB Type-C (TBT4)
    USB 3.2 Gen 2 DP 1.4a
    PD 3.0); 1 x USB 3.2 Gen1 Type A
    Camera
    1x 1080P FHD IR/RGB Hybrid with Privacy Shutter and Dual Array Microphone
    Graphics
    1x Intel® Iris® Xe Graphics
    Monitor
    14" WUXGA
    Form Factor
    Convertible Notebook
  • Windows 11 Pro 25H2 Build 26200.9168 (Wifes)

    Yoga 7 2-in-1 14IML9 - Type 83DJ

    Processor: Intel® Core™ Ultra 7 155H Processor(Core™ Ultra 7 155H)

    Memory: 32GB LPD5X-7467

    Hard Drive: 1 TB SSD PCIe

    Wireless Network: 1x Wi-Fi 6E 2x2 AX; Bluetooth® 5.1 or above

    Ports: 1 x HDMI 2.1 TMDS; 1 x Novo Button; 1 x Combo Audio Jack
    2 x USB-C (USB 4.0)
    1 x USB-A 3.2 Gen 1

    Camera: 1080P FHD IR Hybrid with Dual Microphone

    Graphics: Intel® Arc™ Graphics

    Monitor: 14" 2.8K

    ...Where's my horse?
You must log in or register to reply here.

Similar threads

  • Article Article
Introducing the new Get Data dialog in Excel for Windows
Replies
0
Views
544
Brink
Brink
  • Article Article
What is New in Excel for August 2026
Replies
0
Views
798
Brink
Brink
  • Article Article
What is New in Excel for June 2026
Replies
0
Views
284
Brink
Brink
  • Article Article
What is New in Excel for May 2026
Replies
0
Views
207
Brink
Brink
  • Article Article
Introducing federated Copilot connectors for LSEG and Moody's in Excel
Replies
0
Views
179
Brink
Brink

Latest Support Threads

Latest Tutorials

Back
Top Bottom