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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aspendus
New Member

UDF query help

Hi! Question: I have some data in an external database, which I can query in PowerBI through DirectQuery. However, I also have a UDF (user defined function) in that external database that takes some input parameters and then performs a Select query and returns the results the way a normal select query would do. Is it in any way possible to call this UDF from PowerBI? All I've found so far is how to use SQL/DAX to write a new query, but I already have my (complicated) query in that UDF and I don't want to rewrite it in each external tool that needs to use it. Thanks!

1 ACCEPTED SOLUTION
Rayshin
Memorable Member
Memorable Member

@aspendus  You can make a parameterized view that uses your function, then PBI thinks it's a regular select query

There's a little information here. https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

View solution in original post

1 REPLY 1
Rayshin
Memorable Member
Memorable Member

@aspendus  You can make a parameterized view that uses your function, then PBI thinks it's a regular select query

There's a little information here. https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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