The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
@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
@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