https://community.fabric.microsoft.com/t5/Report-Server/Help-How-to-configure-a-ScaleOut-for-a-Data-model-Refresh/m-p/1901923#M19723 <P>Hi All,</P><P>&nbsp;</P><P>We need to have the following configuration with 2 servers where PBIRS is installed :</P><OL><LI>The first one acts as a Front-End server&nbsp; (interactive report processing)</LI><LI>The second one acts as a back-End server, in particular it accepts all the data model refresh requests (scheduled report processing).</LI><LI>On the PBIRS confirmation of each server, the scale out section contains both servers</LI></OL><P>Question is: How can we force&nbsp;that the first&nbsp;one is used for interactive report processing and the second one will perform the data model refresh?</P><P>&nbsp;</P><P>Microsoft documentation is the following (but not clear to me):<BR /><A href="https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15" target="_blank">https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15</A></P><P>Thanks for your help!</P><P>&nbsp;</P><P>Karim</P> Tue, 15 Jun 2021 16:49:45 GMT karimdiouf 2021-06-15T16:49:45Z https://community.fabric.microsoft.com/t5/Report-Server/Help-How-to-configure-a-ScaleOut-for-a-Data-model-Refresh/m-p/1901923#M19723 <P>Hi All,</P><P>&nbsp;</P><P>We need to have the following configuration with 2 servers where PBIRS is installed :</P><OL><LI>The first one acts as a Front-End server&nbsp; (interactive report processing)</LI><LI>The second one acts as a back-End server, in particular it accepts all the data model refresh requests (scheduled report processing).</LI><LI>On the PBIRS confirmation of each server, the scale out section contains both servers</LI></OL><P>Question is: How can we force&nbsp;that the first&nbsp;one is used for interactive report processing and the second one will perform the data model refresh?</P><P>&nbsp;</P><P>Microsoft documentation is the following (but not clear to me):<BR /><A href="https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15" target="_blank">https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15</A></P><P>Thanks for your help!</P><P>&nbsp;</P><P>Karim</P> Tue, 15 Jun 2021 16:49:45 GMT https://community.fabric.microsoft.com/t5/Report-Server/Help-How-to-configure-a-ScaleOut-for-a-Data-model-Refresh/m-p/1901923#M19723 karimdiouf 2021-06-15T16:49:45Z https://community.fabric.microsoft.com/t5/Report-Server/Help-How-to-configure-a-ScaleOut-for-a-Data-model-Refresh/m-p/1903796#M19736 <P>Please see:</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/Report-Server/How-to-segment-report-server-applications-on-different-servers/m-p/1896121#M19683" target="_blank">https://community.powerbi.com/t5/Report-Server/How-to-segment-report-server-applications-on-different-servers/m-p/1896121#M19683</A></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 16 Jun 2021 12:15:17 GMT https://community.fabric.microsoft.com/t5/Report-Server/Help-How-to-configure-a-ScaleOut-for-a-Data-model-Refresh/m-p/1903796#M19736 pabeader 2021-06-16T12:15:17Z