Forum Discussion
Helper IIPower BI Report Server: Not Able to Refresh
Thank you Vanchy_Liao
Hi, lynnma
First, you need to check whether the following service URL can be accessed normally:
It should look something like this:
If you can't access it, you can't create a scheduled refresh. Here are some things you need to try:
1. Try to use a domain user with permissions:
2.Try using the sa as the database credentials:
It is recommended to open the browser developer mode and check the error code, which should be the following query:
Finally, check your log file below:
The log file will be located in your installation directory, and below is the default path
C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFilesIf 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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-Jianpeng-msft,
Thank you very much for providing this reponse. As it turns out, this was the solution. Implementing the suggested changes solved the problem after a complete shut down and start back up of the Power BI Report Server. I scheduled a refresh for a Power BI Dashboard that pulled over 8 million records with aggregations successfully. The refresh of the data took less than 30mins to complete.
Thank You Very Much!
Extremely Appreciative,
Mark L.
Hi, lynnma
Thank you so much for coming back here and for the helpful information. Based on your last reply, I found out that there are no items in your web portal, which is the core reason for the occurrence: The item '/Any dashboard published' cannot be found.
Try accessing the Web service url directly instead of the domain name to check if there is a problem with the Report Server configuration.
If the URL in the web service is accessible and displays any items in your web portal, there is a problem with your domain access.
Normally, there are some folders in your web portal that will also appear on this page:
It is recommended that you press F12 to open the browser developer mode when opening the web service URL and check the error message:
If your environment allows you to reconfigure Report Server, you may want to consider reconfiguring it. This method is the last resort, and you should not even choose it until you have checked the previous information. To reconfigure, you need to pre-retain your reports locally. If you're just getting started with Report Server and only have a small number of reports (with copies locally), you might want to consider it.
Or you can configure it in your other test machines to determine whether the configuration is successful, and you need to meet the following two points:
1. The web service url can access and display any project on the Power BI Report server normally
2. Be able to access the Web Portal URL normally and enter the portal.
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.
Helper IIHi V-Jiampeng-Msft,
The feedback you provided is the exact same steps I already have taken to open the URL, which is how I was able to take a screen shot and post it here in this forum, thank you.
I appreciate your feedback and attention in this matter. Can you please provide steps to re-configuring the report server? What part needs to be reconfigured?
Please provide feedback, thank you.
Mark L.