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
gopinathtk's avatar
gopinathtk
New Member
19 hours ago

Hello andyclap​

You're not alone in experiencing this. The new Power Query experience has some known performance limitations, particularly when opening reports containing multiple queries or large mashups.

Microsoft has acknowledged that preview results can be delayed while other query operations are being processed, sometimes leaving the editor temporarily unresponsive.

My suggestion would be to try disabling the new experience:

  1. Go to File → Options and settings → Options.
  2. Open Preview features.
  3. Uncheck "New Power Query experience".

This should take you back to the legacy Power Query Editor, where you can switch between queries without the same new-UI behaviour.

You can also experiment with the background data preview settings under Data Load, although this may not completely resolve the issue.

Hopefully Microsoft will improve the initial loading and preview performance in future updates.