Forum Discussion

darentengmfs's avatar
darentengmfs
Post Prodigy
6 years ago
Solved

Add Index Function causes refresh to fail

Hi,   I have a query that is created by 2 other queries. I added an index column using the built-in index column function and it loads just fine in Power BI and refreshes just fine. However, when I...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Try without the column type

     

    #"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 1, 1)

  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi darentengmfs ,

    As lbendlin said: Removing this newly added optional 5th parameter should solve the issue.

    Alternatively you have to update the gateway in the service to the newest version. That should fix the problem as well.

     

parry2k's avatar
parry2k
Super User
6 years ago

darentengmfs don't see any issue though. can you remove sort step and then add index. Can you test it, please?

darentengmfs's avatar
darentengmfs
Post Prodigy
6 years ago

Hi parry2k 

 

The sort has to be there before the index column. It is sorted descending on value because I had to get the rolling sum of value from highest to lowest.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    darentengmfs hmmm, only for testing...just want to debug this.

    • darentengmfs's avatar
      darentengmfs
      Post Prodigy
      6 years ago

      Hi @parry2k

      Sorry it took so long. I removed the sort and the problem is still the same

      Daren

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        darentengmfs - I don't see anything obviously wrong with the AddIndexColumn statement. However, try adding a Table.Buffer statement between your Sort and your adding of the index column. Maybe ImkeF has some thoughts.