cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors