Dennis Yee
New Member
Members
Dashboards
Power Query
Power Pivot
Power BI
Dashboards
Power Query
Power Pivot
Power BI
Forum Posts: 1
Member Since:
February 22, 2017
February 22, 2017
Offline
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
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Michal Kučera
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33708
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —