Power Pivot refresh error on Refresh All, but works when refreshing one by one

Andrea Morillo 1 Reputation point
2021-12-17T00:36:21.33+00:00

I have an data model in Power Pivot that reads from an Access Database. The connection is set to Refresh All automatically when the file is opened. It had been working smoothly until today.

When opening the file, I am getting the error "The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source". Needless to say, none of that is true. The structure of the database has not changed, nor the location or table names.

Interestingly, when I go into the data model in Power Pivot and refresh each table individually, the connection works and the data flows without errors. There are no errors on individual refresh.

Any thoughts?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
34,903 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,613 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,461 Reputation points
    2021-12-17T09:22:32.82+00:00

    Hi @Andrea Morillo ,

    Welcome to Q&A forum.

    Please make sure your computer is online, when you connect to the Internet, please click refresh all to have a check.

    Besides, I suggest you check whether the article is helpful, “I Modified an Existing Table in Power Query and Now it Won’t Refresh”– A Fix
    (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.