Results 1 to 2 of 2

Thread: Could Not Refresh the connection Query
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2015
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Could Not Refresh the connection Query

    Hi Everyone I'am experiencing problem in refreshing the connection of my query. I used my 2015 and 2016 data as a start file in my power query. But every time I add my 2017 data and refresh my power query I always get this message.
    "Index is out of range(Should be bigger or equal to 0 and smaller than Count)
    Parameter name: index
    Actual value was 29."

    I hope someone can enlightened me regarding on my problem. Any help will be greatly appreciated. God Bless.

  2. #2
    Board Regular MarcelBeug's Avatar
    Join Date
    Apr 2014
    Posts
    1,811
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Could Not Refresh the connection Query

    This is probably similar to the issue that was recently reported on TechNet.
    Last edited by MarcelBeug; Jan 31st, 2017 at 05:48 AM.
    Specializing in Power Query (M).
    Using Excel 2007 (Dutch) and Excel 2016 (Office 365 ProPlus) (Dutch/English), both on Windows 10.
    Array formulas can be recognised by the {} Excel puts around it automatically when you press Ctrl+Shift+Enter upon formula entry.

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
  •