Results 1 to 2 of 2

Thread: We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2012
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server

    I have been building Call center Planning Models on Power Pivot 2013, and in concept, it's great. I am marrying forecast data sheets to actual data sheets and using a myriad of lookup tables to glue it all together. The program doesn't seem to have a problem picking up new data on the actual results and forecast data sheets as I update them. For some reason, the lookup tables have an issue refreshing, whenever I add something to them, or when there is a change in the data. No new column, just adding rows to the bottom, or editing what is already there. Sometimes they do update when their is a change, sometimes they don't. When they don't I get the dreaded, "We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server". The only fix I have been able to do so far is to re-import and rebuild the areas of the workbook that are involved, re-do the relationships, etc. This is not really acceptable as it is a huge pain in the neck, and I couldn't roll something like this out to others in this unstable state.

    So the question is, can someone tell me the best practice for putting something like this together. Current state is that I have a workbook with a lookup table per tab. I import these tables from this one workbook to multiple Power Pivot Workbooks. Would it be better to house the tables in Access? I really want to centralize these tables, and not have to have a complete set of these tables in every power pivot workbook. I have searched on the web, and have not found a solution. The models work great, until something changes. I should not have to rebuild the model every time I incorporate more areas in these tables.

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server

    There is nothing wrong with your approach - it is perfectly valid. Unfortunately it is very difficult to work out what the issue is. Have you tried loading the tables using Power Query? I am not saying it is better (or worse), just different.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •