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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
AshaZeng
Frequent Visitor

Power Query Refresh Speed is very slow

Below applied step in my power query is normal.

AshaZeng_0-1720590671485.png

However, after I inserted below two steps before above step, the refresh speed becomes very slow

AshaZeng_1-1720590825996.png

AshaZeng_3-1720590849275.png

Not sure what happens, anyone knows what I should do to speed up the refresh?

By the way, I only 40 rows in Power Query.

Below is my whole M code, hope it could help to find the main issue~

AshaZeng_2-1720597767458.pngAshaZeng_3-1720597799764.png

 

 

 

 

4 REPLIES 4
Anonymous
Not applicable

I would use List.Buffer(ListName) to buffer the list. That will speed things up.

 

--Nate

m_dekorte
Super User
Super User

Hi @AshaZeng 

 

Store the table you are referencing, for each row in the table, into a separate variable; Lookup

Test if buffering that Lookup table helps to speed things up, as illustrated below.

 

Lookup = Table.Buffer(Table.Distinct(Table.SelectColumns(#"Reordered Columns2",{"CBL Number","FCR Number"}))),
YourStep = Table.AddColumn(#"Reordered Columns2", "FCR Quantity", each List.Count(Table.SelectRows( Lookup,(x)=>x[CBL Number]=[CBL Number])[FCR Number]))

 

 

Alternatively, consider a Merge that is often more performant than selecting rows since you have a shared key, the CBL Number column in both tables. Then count rows in the table that's returned...

 

I hope this is helpful.

AshaZeng_0-1720596849873.pngAshaZeng_1-1720596893808.png

 

 

 

Thanks so much for your reply, but it does not work, above is my whole M Code, can you find the key issue which resulted in the slowness performance?

Hi @AshaZeng,

 

Sure, I'd be happy to help you improve that query. Here are a few suggestions to get started:

- Remove redundant steps (such as reorders and renames)
- Consolidate value replacement steps
- Combine new field creation steps

 

If you need further assistance, please share a link to an excel file with representative dummy data, including the current state of your query. You can upload it to OneDrive or Google Drive, ensure it is accessible for anyone to download.

 

I hope this is helpful

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.