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\LogFiles

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

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.