PowerQuery - There's a problem with the clipboard, but you can still paste... Error repeating many time during query refresh

user_2094217 0
Viewed 1711

Whenever I refresh my data queries (Quite large) I am getting the following error some number of times seemingly randomly repeating until the table eventually loads the rows. I have to click ok or hold ok until it is done. It can be a 30min delay per table.

I have googled and directly searched stack overflow to no avail. Within the general settings I disabled preview and its had no impact.

enter image description here

powerquery excel
1 Answers

As I can see you are using Windows 10, you can try turning off "clipboard history" in settings > system > clipboard.

This worked for me when I had the same error message in MS Excel, so I assume it will work here as well.

I have read that the problem is due to the clipboard being locked by other running applications.

See similar questions (without solutions) here and here.

user_134787380
Related