Forum Discussion
Query refreshing slow
why specific query takes more time to refresh during refreshing report??
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
2 Replies
which one? 😉
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
