Forum Discussion

RobertXiong's avatar
RobertXiong
Icon for Helper II rankHelper II
4 years ago
Solved

Cannot create Scheduled Refresh Plan on on-premises Power BI Report Server

Anyone can help with this?  I created report and uploaded it on Power BI Report Server (on-premises), it worked fine when I opened it from report server. right now I want to refresh data daily from ...
Cannot create Scheduled Refresh Plan on on-premises Power BI Report Server
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    RobertXiong  

     

    That's strange, there is no specific error message, so it is difficult to determine the problem.
    Try to restart the sql database service in machine. 

    Is the RS report in the production environment from the previous test environment or is it newly uploaded?

    If it still doesn’t work, I’m afraid you have to reinstall RS. 

    Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

     

    Best Regards,
    Community Support Team _ Janey

  • 斥敌's avatar
    斥敌
    4 years ago

    我也遇到过这个问题。

    后来我查看D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles日志，发现是权限的问题。设置能够完全控制下面这个路径的文件夹即可。

    或许你也可以检查一下对这个文件夹的访问权限。

     

    appdomainmanager!DefaultDomain!1cc0!07/02/2021-16:45:00:: e ERROR: AppDomain ReportServer error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_PBIRS_1. ---> System.UnauthorizedAccessException: 对路径“D:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\RSTempFiles\~AspAccessCheck_81fb13747360.tmp”的访问被拒绝。
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Team,

    I am also facing the similar issue in my prod environment. However it is a painful to restart/reboot the service to get it resolved. Is there any alternate ways to handle this error.

     

    Currently when ever i am getting this error below steps i am following which is not a candidate for production environments.

    1. Clearing SQL Logs in SSMS.

    2. Restarting the service and also Rebooting mechine.(Which may not required).

    3.All the credentials are correct only.

     

    Please support me to solve the Issue.

     

    Thanks & Regards,

    Phanikumar B

RobertXiong's avatar
RobertXiong
Icon for Helper II rankHelper II
4 years ago

The data source is oracle database 12c. The other reports couldn't refresh neither.

 

I had testing environment, the Power BI Report Server and the SQL database of PBIRS are in same server, the data source was oracle as well. I could create scheduled refresh plan in testing environment. 

Right now I am going to create production environment. the report server is same, but the SQL database server is in another windows server.  

 

are there procedures to debug this kind of issue?

 

Thanks so much

 

Robert Xiong

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, RobertXiong 

 

The SQL database corresponding to RS must correspond. I think the problem should be here. 

  • RobertXiong's avatar
    RobertXiong
    Icon for Helper II rankHelper II
    4 years ago

    I cannot follow you what the mean of "The SQL database corresponding to RS must correspond" is . would you like to tell me more?

    Thanks so much.

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      RobertXiong 

       

      Each RS backend has a SQL server to store data. I don’t know if your test environment and production environment use the same RS.

      • RobertXiong's avatar
        RobertXiong
        Icon for Helper II rankHelper II
        4 years ago

        In my production environment, I used old RS (was RS in test environment) as production RS,  this backend database was changed to connect to remote SQL Server   

        I don't use test RS anymore.

         

        Thanks