Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register 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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
42 | |
30 | |
27 | |
27 |