Power Pivot Refresh Failure

  • gracebite

    Right there with Babe

    Points: 725

    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

  • sbelche-760308

    SSC-Addicted

    Points: 437

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply