Forum

Refresh Power Query...
 
Notifications
Clear all

Refresh Power Query taking too long

2 Posts
2 Users
0 Reactions
103 Views
(@dennisysy)
Posts: 1
New Member
Topic starter
 

Hi,

I was just wondering if someone has tried to append some worksheets and having difficulty to refresh the append query? I have to wait for hours and yet it still running background query, I can see it's only a 5,500 rows to be loaded but is that a faster way to refresh? Hope someone can help, thanks.

Dennis

 
Posted : 01/04/2017 12:00 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Dennis,

It shouldn't take that long. Please provide more details about the queries. What are the sources of the data. What are the queries doing? If you're able to share the M code that might reveal some insights about the possible cause.

Of course nothing is better than the actual file(s), so if you can share them that would be ideal.

Mynda

 
Posted : 04/04/2017 12:41 am
Share: