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 created a function to find the working days in Power Query. As soon i call that function in the custom column, the loading of data get extremly slow, like loading 1 row per second (in both data preview and loading). Need suggestions on how to optimize my model. Folloing methods i have tried already,
1) Adding Table.Buffer(dataset) as a step before adding the custom function.
2) Adding Table.Buffer(dataset) as a step right after the source (with no further applied steps)
Both scenarios gives me an error of A cyclic reference was encountered during evaluation.
Thanks in advance.
I have created a function to find the working days in Power Query
Why? This data is immutable. Use an external calendar reference table.
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.