Skip to main content

New Power Query experience in Power BI Desktop (Preview)

Getting data is the starting point of almost every Power BI workflow. It’s where users connect to their data, explore what’s available, and begin shaping it for analysis.

As a joint effort between the Data Integration and Power BI teams, we are introducing the Preview of the new Power Query Get Data experience in Power BI Desktop—a completely redesigned way to help you discover and connect to your data faster. 

Why we built a new Get Data experience?

Over time, the number of connectors and data sources in Power BI has grown significantly. While this brings flexibility, it also introduces friction—especially when users are trying to quickly find the right data source or understand how to get started.

At the same time, we’ve been evolving Power Query across Fabric experiences. This created an opportunity to rethink the Get Data flow end-to-end and align experiences across Desktop, Fabric, and beyond.

The result is a modernized experience built on three key principles:

  • Faster discovery of data sources
  • Simpler connection flows
  • A more inclusive and accessible experience

What’s new

The new Get Data in Power Query experience introduces a redesigned interface that helps you go from “no data” to loading and transforming it in a more streamlined flow with less friction.

New Get Data experience in Power BI Desktop

A simpler way to find your data

The experience introduces a streamlined left-hand navigation pane that helps you quickly find and select the right data source:

  • Home provides quick access to commonly used entry points and connector search.
  • New offers the full catalog of available connectors.
  • Recent data helps users quickly reconnect to previously used sources.
  • OneLake Catalog enables discovery of accessible Fabric data items directly within the experience. This experience also introduces enhancements such as the ability to easily choose your preferred connectivity mode.
  • Blank Table provides a faster entry point for manually creating and pasting data into a table.
  • Blank Query provides a faster entry point for custom M authoring and advanced query scenarios.

Choosing a connectivity mode in the OneLake Data Hub

A more streamlined connection experience

Connecting to data is now more cohesive, reducing context switching between dialogs and making it easier to configure settings and authentication in one place. This helps you move faster from selecting a source to previewing and shaping your data.

Configuring the connection settings and authentication for a selected data source in a single step

Built with accessibility in mind

In addition to streamlining the workflow, the new experience has been designed with usability and accessibility in mind. It includes full keyboard navigation support, enabling more efficient interactions without relying on a mouse, and , providing a more comfortable viewing experience in low-light environments.

Dark mode support in the new Get Data experience.

Impact for users

Whether you’re a new user or an experienced data professional, the new Get Data experience helps you:

  • Spend less time searching for data sources
  • Move more quickly into analysis and modeling
  • Work more comfortably across different environments

Get started

The new Get Data experience is available in Preview in Power BI Desktop. To enable it:

  1. Launch Power BI Desktop
  2. Go to: File> Options and settings> Options>Preview feature, and enable the checkbox for “New Power Query experience”
  3. Select ok
  4. Restart Power BI Desktop
  5. Select Get data and get started!

Enabling the new Power Query experience from Preview features in Power BI Desktop.

Comments

Popular posts from this blog

SSRS INTERVIEW QUESTIONS

Q: What is SSRS? Ø   SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø   It is used for preparing and delivering interactive and variety of reports. Ø   It is administered through an web based interface. Ø   Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø   SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø   SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Failed to execute the package or element. Build errors were encountered

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package