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:
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: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Nicole White
Adrian Macleod
Ed Norris
manoj Ka
Chris Cowan
Pawel Ganczarski
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30127
Member Stats:
Guest Posters: 49
Members: 33678
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —