Adding index causes dataflow to fail

[Banzai]

Run into an unexpected refrhsh failure this morning and was able to isolate is to index creation with the simple script below.

Run time	Dataflow name	Dataflow refresh status	Entity name	Start time	End time	Entity refresh status	Error
08/02/2020 10:14	IndexFail	Failed	Query	02/08/2020 10:14	02/08/2020 10:14	Failed	Error: 5 arguments were passed to a function which expects between 2 and 4... RootActivityId = 78c6f17c-1fe6-4fa6-a040-55319f036eb5

Script:

let

  Source = {1..10},

  #"Converted to table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

  #"Changed column type" = Table.TransformColumnTypes(#"Converted to table", {{"Column1", type text}}),

  #"Added index" = Table.AddIndexColumn(#"Changed column type", "Index", 0, 1, Int64.Type)

in

  #"Added index"

[v-yuta-msft]

@Banzai ,

I could refresh the dataflow without any issue. Do you have other data sources in your report?

Regards,

Jimmy Tao

[alexwhittles]

I've found exactly the same problem when using Table.AddIndexColumn.

Works fine in PBI Desktop, but will not refresh from the service.

The workaround is to remove the 5th parameter (the datatype, Int64.Type) and add that as a subsequent step in Power Query.

Microsoft please look into this as it is definitely a problem with PQ in the service.

[Banzai]

No, no other datasources in this particular dataflow. Removing the index creation line resolves the problem and the dataflow runs fine. Can apply the workaround that @alexwhittles just posted. Thanks!

[alexwhittles]

Found the problem that was causing mine to fail; running an older gateway.

The July 2020 gateway (3000.51.7) is required to support 5 parameters. I updated to that and it works ok after that.

Alex

[Anonymous]

^ im on Aug 2020 gateway, 3000.54.8, but still running into this. 

5 arguments were passed to a function which expects between 2 and 4

[Anonymous]

confirming that the workaround provided works:

The workaround is to remove the 5th parameter (the datatype, Int64.Type) and add that as a subsequent step in Power Query.