Power Query Freeze on Refresh

Anonymous 

Since there weren't any error messages, time out may occurred.

If there are advanced operations(e.g merge, append, reference other steps, invoke custom functions...) with large data, they will cause the looping calculation and duplicate cost on memory resource, You can refer to following:

Referenced Queries And Caching In Power BI And Power Query

How and When to use List & Table Buffer?

You can also try to increase the cache limits.

1. Click Settings->Options->Global->Data Load to expose the "Data Cache Management Options".

2. Try increasing the Maximum allowed (MB):to 16000 (or about double what the current setting is)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.