Forum Discussion
Rookarumba
Helper III
Helper IIIApply Query Changes : Taking too long , like hours or so
Hi Everyone, My "Apply query changes' is taking far too long. This wasn't the case when I was working on the same dataset (2m rows) of data. Recently I did some changes and removed some of th...
Rookarumba, this happens when you refresh data at the point of time when combined data set is refreshed. Data extracts are quick, but not union operarion. Im not even saying about data transformations.
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.
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.
RookarumbaHelper III
Helper IIIlaggerok19 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)