Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Expression.Error: We cannot convert the value "[Function]" to type Function

I have a report that I'm converting to a PBIT and then moving to another location to create a PBIX. This will involve changing some parameters to connect to other data sources.   I'm getting a prob...
Invoke Custom Function
Type conversion
rohit1991's avatar
rohit1991
Super User
1 year ago

hi Anonymous ,

This happens when Power Query loses the function reference after exporting to .PBIT.

Solutions:

  1. Revalidate PriorVisitIEN in Power Query.
  2. Reapply "Invoke Custom Function" manually.
  3. Ensure the function is defined before usage in applied steps.
  4. Use explicit reference: = Table.AddColumn(#"Changed Type", "Prior Visit", each @PriorVisitIEN([EPI], [IEN]))
  5. Check parameter types to match function inputs.