none
Index out of range on old query RRS feed

  • Question

  • I have a date table and also a seasonality table which is simply a month number and a weighting. The month no on the date table and on the seasonality table are related. Recently I started getting this error if I refresh the seasonality table. The data model seems absolutely fine and has no errors

    I have no idea what this is trying to tell me? I've tried deleting the query and adding it back form scratch, but get the same result. I have a 2nd table with Weekly pattern so related by day of the week with the same kind of error.

    Any help appreciated.

    Mike

    Wednesday, May 17, 2017 4:22 PM

Answers

  • https://support.office.com/en-us/article/When-you-try-to-refresh-a-Get-Transform-model-query-in-Excel-2016-you-get-an-error-174b60ee-c72b-4a23-bbd2-b80681626da6?ui=en-US&rs=en-US&ad=US

    • Marked as answer by masplin Friday, May 19, 2017 1:45 PM
    Wednesday, May 17, 2017 7:57 PM

All replies

  • https://support.office.com/en-us/article/When-you-try-to-refresh-a-Get-Transform-model-query-in-Excel-2016-you-get-an-error-174b60ee-c72b-4a23-bbd2-b80681626da6?ui=en-US&rs=en-US&ad=US

    • Marked as answer by masplin Friday, May 19, 2017 1:45 PM
    Wednesday, May 17, 2017 7:57 PM
  • I#m on version 1701 so that hast actually been fixed. However you were right it was caused by the trailing spaces in my column names so just removed them and reconnected the tables

    Thanks very much

    Friday, May 19, 2017 1:45 PM