Power BI Report Server: Web portal shows an error when opening any report

[DeepEureka]

Hi,

We can browse through the folders inside our PBIRS Web Portal, but when we try to open a report.
A pop-up message appears saying that "An error has occured. Something went wrong. Please try again later".

How can we get more info of what is getting wrong? 

We are using PBIRS September 2024 and everything was working fine untill we tried to change logs to verbose mode, changing values in "ReportingServicesService.exe.config" file from value 3 to 4. 

We reverted to the previous configuration in that file but problem persist in Web Portal.

Any suggestion?

Edit: I looked at RSPowerBI*.log files. I see a FATAL error in the log if it helps.

Thanks,

David 

[Anonymous]

Hi, @DeepEureka 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[DeepEureka · Accepted solution]

I finally could solve it deleting all bindings from Report Server Configuration Manager, then creating them again.

Steps:

1. Remove all urls from Web Portal URL Section
2. Remove all urls from Web Services URL Section (one could not be deleted). I added a new one, and then deleted the "old" one.
3. Add url again to Web Services URL 
4. Add url again to Web Portal URL

This recreated again the bindings to urls (correctly). I guess there was a conflict between bindings/ports and denied acces to the service running the report server service that was raising the mentioned error.

It can be useful to run cmd (as admin) netsh http show urlacl to detect these kind of conflicts between urls and users with autorization to listen to this url/ports.

[Anonymous]

Hi, @DeepEureka 

Thank you for coming to the Report Server forum.
Based on the screenshot of the error log you provided, I noticed a key error message:

Access is denied

Your error message:

System.Net.WebException: Access is denied
   at System.Net.HttpWebRequest.AbortInternal()
   at Microsoft.PowerBI.ReportServer.AsynchronousReportService.<RenderReport>d__7.MoveNext() in D:\a\_work\1\s\src\Microsoft.PowerBI.ReportServer.AsynchronousReportService.cs:line 123
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.PowerBI.ReportServer.AsynchronousReportService.<Render>d__6.MoveNext() in D:\a\_work\1\s\src\Microsoft.PowerBI.ReportServer.AsynchronousReportService.cs:line 87
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.TraceError(String message, Object[] arguments, IFormatProvider formatProvider)
   at Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.TraceError(String message, Object[] arguments)
   at Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.TraceError(Exception e)

This error message indicates that there is a problem with your Report Server in the permission configuration, causing an error to be triggered when your current user accesses.
You can check the permission configuration anywhere in your Report Server:

Files Permission:

Web Portal folder

Web Portal:

Report Server install folder:

You describe that you have changed the configuration file of the report server. If you have some configuration that doesn't change back, it will cause this problem. Try reconfiguring the Report Server.

You can also check other log files to see more specific error reports.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DeepEureka]

Hi,

The problem persist. I can't access to any of the screens related to permissions in Power BI portal that you show, it triggers the error.

Regarding Windows folder containing Power BI Report Server instalation, which users should have which permissions? The configuration manager is using built-in user, so it is unclear to me which user should have permissions.

What do you mean by reconfigure in the configuration manager? Which options should I modify?

Thanks,

D

[Anonymous]

Hi, @DeepEureka 

If it is As the user viewing the report, you need to check whether your current account has permission to access the corresponding data source:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.