SQL user defined function not executing on server via gateway

[Kartic21]

I am using SQL user defined function in the SQL query as a import mode. File is getting refreshed fine on PBI desktop however on PBI server it is failing stating SQL user defined function "The EXECUTE permission was denied on the object".  

Same gateway is  able refresh file wrt to tables in SQL used however with SQL user defined function it is failing.

Does gateway refresh dont support SQL user defined function or any permission issue might be there?

Thanks in advance for providing the inputs

[Kartic21]

@lbendlin 

I tried using the underlying query without UDF and it seems to work on  serevr . However with UDF included it seems to break and not getting refresh.

Does gateway powerbi refresh support SQL UDF ?

[Kartic21]

underlying query without UDF is executing good on the server .

However when UDF is included in the query it fails

[lbendlin]

Check that the "owner" of the gateway connection (ie the credentials) has the necessary permissions on your SQL server.  Try running the underlying query instead of the UDF.