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.
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
Rookarumbaopereira, do you have a sample query which you can share?
maybe i can take a quick look and see if im able to help