Different refresh scenario under 365 and 2016

[Chris_23]

Hallo guys,

i've built a Excel-report with some query and vba components on Microsoft365. Everything works fine if the user has an 365 license. however, if the user has a 2016 standard license the report doesn't work right.

-> While running one query follow error comes up: 5 arguments were passed to a function which expects between 2 and 4
Problem: Insert a Index column: #"Hinzugefügter Index" = Table.AddIndexColumn(#"Entfernte Duplikate", "Index", 1, 1, Int64.Type)

If i deleate ", Int64.Type" the futher steps in the query work, but

it seems that the single queries need more time to load, if the user has a 2016 license. In result that the produced outcome in the report is not to use.

Any idea how to handle the problem?

Kind regards

Chris

[Anonymous · Accepted solution]

Hi @Chris_23 ,

Based on my test, there must be 4 parameters for Table.AddIndexColumn() in Excel 2016

= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)

and 5 parameters in Power BI , the last one is to define column Type which is optional,as the official document said:

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

=Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)

= Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.