Forum Discussion
Apply Query Changes : Taking too long , like hours or so
I am having a similar issues where I am attempting to load a query from an analysis services connection. The report says it has loaded 970k rows which soulds reasonable, but it seems to be hung up in finishing the job. I've been watching the load for about 45 minutes and am hesitate to walk away for fear that it will time out. Once I get the initial load in I can apply some filters to better scale the data, but I just need to finalze the data connection. My first instinct was to load everything then scale back, but I suppose the next attempt is to load limited data then ramp up. Any other suggestions for a relative novice/non-programmer?
Anonymous ,
my current workaround is rewriting the queries with R instead of M.
So instead of waiting for up to 2 hours for the queries to finish loading, R can finish the job within 15 mins.
Hope this help
- Anonymous8 years agoNot applicable
Thanks for the info. I have not yet done queries in R but will investigate.