Forum Discussion
Helper IIDifferent refresh scenario under 365 and 2016
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
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.
1 Reply
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.