https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3541466#M136087 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="618507" data-lia-user-login="Satya2277" class="lia-mention lia-mention-user">Satya2277</a>&nbsp;,</P> <P>Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.</P> <P><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">How to Get Your Question Answered Quickly&nbsp;</A>&nbsp;</P> <P>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. &nbsp;</P> <P>If that is the case, you can look at the buffer function if it helps:</P> <P><A href="https://blog.crossjoin.co.uk/2022/03/20/new-options-for-the-table-buffer-function-in-power-query/" target="_blank">Chris Webb's BI Blog: New Options For The Table.Buffer Function In Power Query (crossjoin.co.uk)</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Mon, 11 Dec 2023 06:05:11 GMT Anonymous 2023-12-11T06:05:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3538884#M135986 <P>why specific query takes more time to refresh during refreshing report??</P> Fri, 17 Nov 2023 09:53:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3538884#M135986 Satya2277 2023-11-17T09:53:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3538893#M135987 <P>which one? <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Fri, 17 Nov 2023 09:58:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3538893#M135987 lukiz84 2023-11-17T09:58:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3541466#M136087 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="618507" data-lia-user-login="Satya2277" class="lia-mention lia-mention-user">Satya2277</a>&nbsp;,</P> <P>Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.</P> <P><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">How to Get Your Question Answered Quickly&nbsp;</A>&nbsp;</P> <P>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. &nbsp;</P> <P>If that is the case, you can look at the buffer function if it helps:</P> <P><A href="https://blog.crossjoin.co.uk/2022/03/20/new-options-for-the-table-buffer-function-in-power-query/" target="_blank">Chris Webb's BI Blog: New Options For The Table.Buffer Function In Power Query (crossjoin.co.uk)</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Mon, 11 Dec 2023 06:05:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Query-refreshing-slow/m-p/3541466#M136087 Anonymous 2023-12-11T06:05:11Z