https://community.fabric.microsoft.com/t5/Report-Server/Data-refresh-takes-too-long/m-p/459495#M6472 <P>Hello,</P><P>&nbsp;</P><P>we have installed and running Power BI Report server for several month.</P><P>Actually running the very last version:&nbsp;<SPAN class="ng-binding">Version</SPAN><SPAN>&nbsp;</SPAN><SPAN class="ng-binding">1.2.6690.34729</SPAN><SPAN>&nbsp;</SPAN><SPAN class="ng-binding">(March 2018).</SPAN></P><P><SPAN class="ng-binding">We are facing with refresh issues.</SPAN></P><P>&nbsp;</P><P><SPAN class="ng-binding">Sometimes the scheduled refresh takes too long (more than hour) and crash on timeout:</SPAN></P><P><SPAN class="ng-binding">"Message":"Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface.</SPAN></P><P>&nbsp;</P><P><SPAN class="ng-binding">On other times the same report it's running smoothly and data refresh takes about 20 seconds.</SPAN></P><P><SPAN class="ng-binding">PBIX report on server has been not modified, the ammout of data to be refresh are the same and manual refresh in Power BI desktop do not takes longer that 30 seconds.</SPAN></P><P><SPAN class="ng-binding">Any idea why the refresh of the data can have such kind of strange behaviour?</SPAN></P><P>&nbsp;</P><P><SPAN class="ng-binding">Thanks.</SPAN></P><P><SPAN class="ng-binding">Marian</SPAN></P> Wed, 11 Jul 2018 07:28:50 GMT fskhalasm 2018-07-11T07:28:50Z https://community.fabric.microsoft.com/t5/Report-Server/Data-refresh-takes-too-long/m-p/459495#M6472 <P>Hello,</P><P>&nbsp;</P><P>we have installed and running Power BI Report server for several month.</P><P>Actually running the very last version:&nbsp;<SPAN class="ng-binding">Version</SPAN><SPAN>&nbsp;</SPAN><SPAN class="ng-binding">1.2.6690.34729</SPAN><SPAN>&nbsp;</SPAN><SPAN class="ng-binding">(March 2018).</SPAN></P><P><SPAN class="ng-binding">We are facing with refresh issues.</SPAN></P><P>&nbsp;</P><P><SPAN class="ng-binding">Sometimes the scheduled refresh takes too long (more than hour) and crash on timeout:</SPAN></P><P><SPAN class="ng-binding">"Message":"Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface.</SPAN></P><P>&nbsp;</P><P><SPAN class="ng-binding">On other times the same report it's running smoothly and data refresh takes about 20 seconds.</SPAN></P><P><SPAN class="ng-binding">PBIX report on server has been not modified, the ammout of data to be refresh are the same and manual refresh in Power BI desktop do not takes longer that 30 seconds.</SPAN></P><P><SPAN class="ng-binding">Any idea why the refresh of the data can have such kind of strange behaviour?</SPAN></P><P>&nbsp;</P><P><SPAN class="ng-binding">Thanks.</SPAN></P><P><SPAN class="ng-binding">Marian</SPAN></P> Wed, 11 Jul 2018 07:28:50 GMT https://community.fabric.microsoft.com/t5/Report-Server/Data-refresh-takes-too-long/m-p/459495#M6472 fskhalasm 2018-07-11T07:28:50Z https://community.fabric.microsoft.com/t5/Report-Server/Data-refresh-takes-too-long/m-p/1322176#M15692 <P>I also have the same issue. My report is refreshed in few second when I refresh manually but takes 18 min when it is refreshed through schedule.&nbsp;<BR />did you get any solutions for it why does it happen and why is this difference</P> Tue, 25 Aug 2020 09:36:57 GMT https://community.fabric.microsoft.com/t5/Report-Server/Data-refresh-takes-too-long/m-p/1322176#M15692 MaheshDadhich 2020-08-25T09:36:57Z