Forum Discussion
Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to connect to AS
Hello, I need some help figuring out how to get the AS service on one of our report servers to connect to the AS service/model. Here is an example of the logs 2023-06-26 11:44:30.9127|INFO|...
Hi all,
We are experiecing the same error on some of our reports after a server restart. Couple of things we have noticed:
- Only reports in Import mode have the error/issue.
- Reports that have a Live connection to a SSAS tabular model on a different server are unaffected.
- The process msmdsrv.exe is not running. When restarting the PBIRS via Report Server Configuration Manager the process briefly restarts but stops/dissappears again.
No idea of what the root casue of this issue is. A temporary solution was to change a settings in the configuration file: Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\msmdsrv.ini
After setting the <CriticalErrorHandling> setting to 0 the msmdsrv.exe process was able to restart succesfully and the error during report rendering stopped appearing.
<CriticalErrorHandling>0</CriticalErrorHandling>
If someone from Microsoft could comment on this approach or provide a better way to fix this issue. That would be greatly appreciated. Thanks!