Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Power Pivot Refresh Failure Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 6:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 11:07 AM
Points: 25, Visits: 152
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
Post #1443058
Posted Wednesday, April 17, 2013 7:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:48 AM
Points: 45, Visits: 4,074
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.
Post #1443264
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse