Forum Discussion

andyclap's avatar
andyclap
Icon for Advocate IV rankAdvocate IV
4 days ago

Power Query - New UI previews default query, blocking UI

Is there any way to prevent this happening? It used to open pretty much isntantly, now I have to wait a couple of minutes while something happens to the first query and it blocks the UI, meaning I ca...
power bi
Khashayar's avatar
Khashayar
Icon for Resolver I rankResolver I
2 days ago

Hi,

This is a known limitation of the new Power Query experience in Power BI Desktop. Microsoft has acknowledged that the editor can become unresponsive while evaluating queries during initial loading.

Recommended solution:

  1. Go to File > Options and settings > Options.
  2. Select Preview features.
  3. Uncheck "New Power Query experience".
  4. Reopen Power Query Editor to return to the legacy interface. No application restart is required.

You can also try enabling "Allow data preview to download in the background" under Options > Current File > Data Load, although this may not resolve the UI blocking issue.

My recommendation: For now, use the legacy Power Query Editor until Microsoft improves the performance of the new interface.

Microsoft has documented this limitation here:

https://learn.microsoft.com/en-us/power-bi/transform-model/power-query-new-experience-limitations

Khashayar

https://www.linkedin.com/in/khashayary/