Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
meghansh
Frequent Visitor

Power Query Loading slow after calling a function in custom column

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.

1 REPLY 1
lbendlin
Super User
Super User

I have created a function to find the working days in Power Query

Why?  This data is immutable. Use an external calendar reference table.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.