When i try to refresh my Excel Power query, it take ages to refresh and hangs Excel. What is the best way or settings to overcome this issue?

CodePudding user response：

The PowerQuery refresh time depends on the data source you are importing. In your case:

1. Limit the number of rows you are importing
2. Put your data in a csv file on your local drive

CodePudding user response：

You might explore the use of Table.Buffer and List.Buffer. They can help sometimes.