Query refreshing slow

[Satya2277]

why specific query takes more time to refresh during refreshing report??

[Anonymous · Accepted solution]

Hi @Satya2277 ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, have you applied any advanced operations in these queries? (e.g. merge queries, invoke custom function, reference from other query to calculate) They will also spend more time to refresh and process.  

If that is the case, you can look at the buffer function if it helps:

Chris Webb's BI Blog: New Options For The Table.Buffer Function In Power Query (crossjoin.co.uk)

Regards,

Xiaoxin Sheng

[lukiz84]

which one? 😉