When attempting to pass the optional parameter columnType to the function Table.AddIndexColumn the parameter is accepted in the query editor but on refresh of the Dataflow it will fail with the error:
"Error: 5 arguments were passed to a function which expects between 2 and 4..."
The documentation @ https://docs.microsoft.com/en-us/powerquery-m/table-addindexcolumn clearly lists the parameter but it would appear that it is not supported in the service.
Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number, optional columnType as nullable type) as table
Eg.
The following query works in the dataflow Query Editor window:
let
Source = Table.AddIndexColumn(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
}),
"Index",
10,
5,
Int64.Type
),
#"Transform columns" = Table.TransformColumnTypes(Source, {{"CustomerID", type text}, {"Name", type text}, {"Phone", type text}})
in
#"Transform columns"
And fails on refresh:
| Run time | Dataflow name | Dataflow refresh status | Entity name | Start time | End time | Entity refresh status | Error |
| Invalid date | BugTest | Failed | Test | 22/07/2020 11:11 | 22/07/2020 11:11 | Failed | Error: 5 arguments were passed to a function which expects between 2 and 4... RootActivityId = 94cb84e9-ccca-4725-b1af-ac495f8b0cb5.Param1 = 5 arguments were passed to a function which expects between 2 and 4. Request ID: 43bd154e-d194-56c3-ef88-76a2d1b3738e. |
Could we get some update to the documentation and a resolution to the issue.
Thanks
mattlee
on:
Problem : Data labels stacked bar chart