Forum Discussion
Power 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.
Just to be clear:
When I acccess the Web Service URL, in the Report Server Configuration Manager, I am 'not' seeing two different folders, as well as several Power BI Dashboards. I do have back up copies of my dashboards. So, I am not concerned with loosing anything at this point.
I am 'not' new to programming developing Power BI Dashboards, as I attended a Power BI Summit Hosted by Microsoft a few years ago, and, have developed Dashboards for different organizations in the past. However, I never installed Power BI Report Server before, first for me and the hospital I work at.
Please provide feedback to re-configuration steps, thank you.
Very Appreciative,
Mark L.
Hi, lynnma
Here's the complete installation and configuration process you can follow:
First, I download Power BI Report Server, here I select the January 2024 version (you can choose a different version):
Download Microsoft Power BI Report Server - January 2024 from Official Microsoft Download Center
Download Microsoft Power BI Report Server - May 2024 from Official Microsoft Download Center
Download Microsoft Power BI Report Server- September 2024 from Official Microsoft Download Center
Here I'm going to take the development version as an example, and you need to deploy it with your corresponding license:
Next, let's start configuring the Report Server:
Next, test if it's configured correctly:
Now let's start uploading a report and setting up a scheduled refresh:
Refresh our report server and you'll find the Power BI report we just uploaded.
Configure credentials and scheduled refreshes:
By following the detailed steps above, you will be able to properly set up a scheduled refresh for your report.
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.
Good Morning,
Thank you for the feedback, but we are not using the Developer, as we have Key(s). Selecting "Developer" is a different process than selecting a "Key." Also, my previous question was not answered pertaining to "Key's." In addition too, we are installing the software on a server, not a desk top computer or laptop. I will continue to look into this and provide feeddback when I am able too.
Very Appreciative,
Mark L.
Good Afternoon Jianpeng Li,
I did not have to complete a full reinstallation, as the problem has been resolved. I will go back to through this communication and mark "Accept as Solution," as well as type in a response. I appreciate everybody's involvement!
Extremely Appreciative,
Mark Lynn.