topic Issue with Gateway with only one report in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-Gateway-with-only-one-report/m-p/803429#M11627 <P>Hello everyone,</P><P>&nbsp;</P><P>Has anyone ever run into an issue where a specific Power BI pbix file seemed to have adverse affects on your on prem gateway?</P><P>&nbsp;</P><P>I had a specific report that was connecting to an AWS Redshift data source and every time I would refresh the report in app.powerbi, I would get an error message saying that the gateway ran into an issue and the gateway may have been restarting (common error it seems like).&nbsp; But it would only happen with that report.&nbsp; It also appeared, although I can't confirm, that the gateway was crashing when I would try to refresh this report and then would restore itself some time later.</P><P>&nbsp;</P><P>&nbsp; I ended up rebuilding it completely from scratch with a new pbix file.</P><P>&nbsp;</P><P>Additional details, all of our reports use AWS Redshift as a data source.&nbsp; They all connect to the same cluster.</P> Thu, 26 Sep 2019 18:22:33 GMT nsadams87xx 2019-09-26T18:22:33Z Issue with Gateway with only one report https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-Gateway-with-only-one-report/m-p/803429#M11627 <P>Hello everyone,</P><P>&nbsp;</P><P>Has anyone ever run into an issue where a specific Power BI pbix file seemed to have adverse affects on your on prem gateway?</P><P>&nbsp;</P><P>I had a specific report that was connecting to an AWS Redshift data source and every time I would refresh the report in app.powerbi, I would get an error message saying that the gateway ran into an issue and the gateway may have been restarting (common error it seems like).&nbsp; But it would only happen with that report.&nbsp; It also appeared, although I can't confirm, that the gateway was crashing when I would try to refresh this report and then would restore itself some time later.</P><P>&nbsp;</P><P>&nbsp; I ended up rebuilding it completely from scratch with a new pbix file.</P><P>&nbsp;</P><P>Additional details, all of our reports use AWS Redshift as a data source.&nbsp; They all connect to the same cluster.</P> Thu, 26 Sep 2019 18:22:33 GMT https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-Gateway-with-only-one-report/m-p/803429#M11627 nsadams87xx 2019-09-26T18:22:33Z