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.

     

darentengmfs's avatar
darentengmfs
Post Prodigy
6 years ago

Hi ImkeF, Greg_Deckler, and lbendlin 

 

I have used Table.Buffer in my sort function but it does not keep the sort when I apply the query. It reverts back when I go to table view. This is not a big issue here because the purpose of the sort in this query is to get the index correct.

 

On the other hand, removing the 5th parameter did help. My report is refreshing now. Some time in the future I have to get my data gateway updated so problems like this will not occur as often.

 

Thanks for both of your help!