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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
aJayMitchell
Resolver I
Resolver I

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.

 

aJayMitchell_0-1713880525653.png

 

3 REPLIES 3
tsnyd111
Frequent Visitor

I'm having this same dataflow custom function issue. Did you find a solution?

v-yilong-msft
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

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors