Forum Discussion

Kartic21's avatar
Kartic21
Icon for Helper I rankHelper I
3 years ago

SQL user defined function not executing on server via gateway

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 EXECUT...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

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.