The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.