Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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_fnand 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_fnand just use @liquidity_date_fn when you call the function
This works. Thank you.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 7 | |
| 4 | |
| 3 |