Forum Discussion

rifaymars's avatar
rifaymars
Helper I
4 years ago
Solved

Refresh reports with PowerShell - PowerBI Report Server(on-premises)

Hello, we are using PowerBI Report Server and automatic reports refresh does not work. I want to use PowerShell to refresh all reports automatically.  All reports are on company' server and we don't ...
PowerShell
  • Icey's avatar
    Icey
    4 years ago

    Hi rifaymars ,

     

    I find some others met the same error with you and they resolved it by uninstalling Power BI Report Server and installed it again.

     

    Or = the cause may be the access to the folder of D:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\RSTempFiles\~AspAccessCheck_81fb13747360.tmp is prevented. So try to give access to it.

     

    Reference: Solved: Re: Cannot create Scheduled Refresh Plan on on-pre... - Page 2 - Microsoft Power BI Community

     

    Please check if this works for you. And before reinstall your PBIRS, it is suggested to back up it.

     

     

    Best Regards,

    Icey

     

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

  • rifaymars's avatar
    rifaymars
    2 years ago

    Last week I installed the new version - Power BI Report Server September 2023, after each new version I test Schedule Refresh. After this version for a first time Scheduler Refresh works!
    I have managed to set it up for all my reports and data sources. Just for web source – it does not work.
    So happy now, I have automated PowerBI reports.

rifaymars's avatar
rifaymars
Helper I
4 years ago

Unfortunately scheduled refresh  is not working since day 1 🙂 I don't know how to figure out why it's not working, that's why I'm trying to search for alternative way.

I got this error:

 

 

Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi

Please ensure your SQL Server Agent is up and running because when you configure a schedule refresh it will create a job in SQL Server agent which will take care of refreshe schedules.

 

Also check below details for more information - https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin


  • rifaymars's avatar
    rifaymars
    Helper I
    4 years ago

    SQL Agent is up and running:

    No jobs related with PBI: