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 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.

    • darentengmfs's avatar
      darentengmfs
      Post Prodigy
      6 years ago

      Hi Greg_Deckler 

       

      I added Table.Buffer at the sort step and it doesn't refresh as well.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        darentengmfs - Hmm, I would still recommend the Table.Buffer. It is often the case that the sorting doesn't "stick" and Table.Buffer tends to solve that. I learned that technique from ImkeF and she may have some thoughts here as well, or possibly edhans .