Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Advocate II
Advocate II

Dataflow in Power BI service freezes when clicking on 'Transform file' query

Does anybody else experience the following issue when working with dataflows within the Power BI service...


When I open a dataflow and click on a 'Transform file' query (created automatically when doing a combine of multiple files), Power Query then freezes somewhat and I'm unale to click onto any other query or setting. The only way to exit without losing changes is to click the 'x' at the top right which then gives me the option to Save or Discard. I then need to go back into the dataflow to do the next edits. Very frustrating and casuing a bit of a bottleneck when making changes.




Community Support
Community Support

Hi @aJayMitchell ,

I think you need to ensure that your Power BI Desktop is up to date, as updates often include fixes for known issues. 

If the issue is related to combining files with inconsistent columns, there’s a solution that involves modifying the Power Query steps to accommodate these differences. You can read this topic: Solved: An error occurred in the ‘Transform File’ query. E... - Microsoft Fabric Community

Sometimes, the freezing can occur due to resource-intensive operations. Reviewing and optimizing your queries for performance might help.




Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yilong-msft

As stated in the title (and the board the post is in), the issue is occuring within a dataflow on the Power BI web service and not on Power BI desktop.

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors