April 16, 2013 at 6:12 pm
Can some one please help about Power Pivot Refresh Failure
I Have created Power Pivot, I can able to create a Power View report, when I am trying to schedule a Refresh Power Pivot
I am getting like "Call to Excel Services returned error" error. I have given trusted file location address and most of the needed configurations
Can you please help me out
Thank You,
Grace
April 17, 2013 at 7:41 am
In my experience with Power Pivot this error usually occurs when you pc memory isn't sufficient to refresh all the tables at once. I haven't found a way around it (although we have upgraded my pc to handle my data requirements). You either have to refresh each table individually after you close every open application (including Excel), reload excel and the power pivot file and then refresh. You may want to review the amount of data you are loading into the power pivot.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply