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.

     

lbendlin's avatar
lbendlin
Super User
6 years ago

Try without the column type

 

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

ImkeF's avatar
ImkeF
Community Champion
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.

 

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    darentengmfs - if you do remove the 5th option, vs updating the gateway, I would recommend one of the last steps in your query is to convert that [Index] type to integer. By default it is a decimal number field. New versions of Power BI Desktop automatically add that 5th step, which I suspect is a model optimization. Integers store and perform better than decimal numbers.