Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a recursive power query custom function that works as expected in Power BI desktop. When I try to use the same M code as part of creating a dataflow or datamart I receive an error message stating "Expression.Error: A cyclic reference was encountered during evaluation." Are recursive functions not supported in the online versions of power query?
For reference the function is below where date is a scalar date value and holidays is a list of dates.
******************************************
Solved! Go to Solution.
This appears to be mostly a visual bug, you can still invoke the function as normal. You can also wrap it in a
let liquidity_date_fn = <code> in liquidity_date_fn
and just use @liquidity_date_fn when you call the function
This appears to be mostly a visual bug, you can still invoke the function as normal. You can also wrap it in a
let liquidity_date_fn = <code> in liquidity_date_fn
and just use @liquidity_date_fn when you call the function
This works. Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.