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
C4YNelis's avatar
C4YNelis
Advocate III
2 years ago

Hi Anonymous ,

 

I realise this is a long time ago, but I just ran into the exact same scenario (not for the first time), so I decided to give it some more time. Maybe it will also help someone else at some point.

 

The problem has nothing to do with your function or function call itself (that is, not with the semantics at least), but you run into the privacy firewall. I for one used a public resource to validate dates from different cultures via the function. Changing this resource to a organizational resource solved the problem. Not really the way I'd like to see things, but it works at least!

 

Thanks to this thread: Expression.Error: Cannot convert the value "[Function]" to type Function (microsoft.com)

 

Cheers,

Niels