Forum Discussion
Adding index column in ADF Power Query
Hi everyone, At the moment I am trying to work around Spark M-code restrictions to create an index column within Data Factory's Power Query. While the option to add an index column is present in...
Re:
While the option to add an index column is present in the interface, when used it will return the error:
"Expression.Error: The Power Query Spark Runtime does not support the function Table.AddIndexColumn."
It's a bit of a surpise that it's in the interface and then fails; I wonder if it's a legacy thing: PQ added an argument to AddIndexColumn, being the last one, the data type. Try missing it out, ie:
Instead of:
= Table.AddIndexColumn(PreviousStep, "Index", 1, 1, Int64.Type)
try:
= Table.AddIndexColumn(PreviousStep, "Index", 1, 1)