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

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I've had the same problem with SSAS tabular. While developing in Visual Studio, Power Query did not complain. After deploying to the server and trying to refresh the corresponding table I was facing the following error message:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] 5 arguments were passed to a function which expects between 2 and 4..
'.

Adding a Index to the table was implemented like this:
Table.AddIndexColumn(#"Replaced Value", "Index", 1, 1, Int64.Type)

After modifing to
Table.AddIndexColumn(#"Replaced Value", "ExtCpty Key", 1, 1)

the table refresh worked on the server as well.

ImkeF's avatar
ImkeF
Community Champion
5 years ago

Interesting Anonymous , that definitely sounds like a bug that you might want to report.