Forum Discussion

adam_mac's avatar
adam_mac
Helper I
5 years ago

Refresh taking forever for only 2 columns

Hi, a topic I’m sure has been covered a million times. I am drawing in data from an OData connection and have created a model with only 2 columns, an ID column and a Country column (I removed 99% ...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi adam_mac ,

If the source table was loaded or quoted multiple times before filtering columns, you can try to use Buffer functions like Table.buffer() etc. to buffers it in memory to improve performance.

Refer:

  1. Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue  
  2. Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query 
  3. Improving Power Query Calculation Performance With List.Buffer() 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.