Forum Discussion
Helper IIIApply Query Changes : Taking too long , like hours or so
Helper IIIlaggerok19 , I'm not too sure if this is a bug but is more on how PowerQuery is refreshing the query when some changes are done on it.
As of today, I'm using a method suggested by Ken Puls (I can't remember what is the name now but i can search for it and post it here again) so the queries won't evaluate everytime.
Also, I've upgraded my RAMs to 32GB and that reduces the queries timing from hours to 15 mins Max.
If you can, I suggest you update your RAM too :)
We have 8 gb RAM to union ～120-150 rows. Completely not applicable performance for application that cost that money.
What is the way suggested? If that it to publish pbx to pbi reporting service and do scheduled refresh, its not our case. SLA mins are 10 min.
- Rookarumba
laggerok19 the RAM works for me :)
this is the other methods Table.Add Key
You can find the blog post by Chris Webb
Literally, you can see that the query didnt rerun for any of your merge functions (if you have a merge function)
I have a report that basically I load few tables from excel file and accessing Windows Insight Usage from our account (Details and Summary) and take hours (6 or more) when a single change is happening. Example change the location of excel file using a new version of values. The application can switch from MSAccess Database from Excel.... In this case is worst. Failed.
Something almost at the end using Excel fail and I have to start over.... Any help will be very appreciated.
Oscar
- Rookarumba
opereira, do you have a sample query which you can share?
maybe i can take a quick look and see if im able to help
