Forum Discussion

Kartic21's avatar
Kartic21
Helper 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 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

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super 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.

  • Kartic21's avatar
    Kartic21
    Helper I
    3 years ago

    underlying query without UDF is executing good on the server .

    However when UDF is included in the query it fails

  • Kartic21's avatar
    Kartic21
    Helper I
    3 years ago

    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 ?