Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Kartic21
Helper I
Helper I

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

3 REPLIES 3
Kartic21
Helper I
Helper I

@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
Helper I
Helper I

underlying query without UDF is executing good on the server .

However when UDF is included in the query it fails

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.