PowerQuery Refresh all takes 30 seconds, front end refresh all takes 20 mins

[doubleclick]

Something happened to my model where the front end refresh takes 20+ mins but the power query refresh is done in 30 seconds - any ideas why?

[doubleclick · Accepted solution]

Not sure what I did but issue now resolved 

[Anonymous]

Hi @doubleclick 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @doubleclick 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

Hi @doubleclick 
Thank you for reaching out microsoft fabric community forum.

If Power Query refreshes in 30 seconds but the front end takes 20+ mins, it’s likely due to what happens after data load  not during it. Common causes include:

• Complex visuals or DAX slowing down rendering

• Large or complex data model (many relationships, high-cardinality fields)

• Heavy calculated columns/measures

• System resource limits (local or service)

• Visuals with lots of data (like big tables or slicers)

Try using Performance Analyzer to spot slow visuals, and test by simplifying or removing some. Also, consider optimizing your model — remove unused columns, reduce relationships, and shift logic to Power Query where possible.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

[samratpbi]

Hi, How you are refreshing? is it in service or Power BI desktop? what are the recent changes you might have made?