Forum Discussion

rifaymars's avatar
rifaymars
Icon for Helper I rankHelper 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
Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

Trying you to understand your scenairo better. why can't you setup a schedule refresh for your reports?

 

Thanks

Hari

  • rifaymars's avatar
    rifaymars
    Icon for Helper I rankHelper 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
      Icon for Solution Sage rankSolution 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
        Icon for Helper I rankHelper I
        4 years ago

        SQL Agent is up and running:

        No jobs related with PBI:

         

    • Icey's avatar
      Icey
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi rifaymars ,

       

      What are your data sources? Are they in the list of supported scheduled refresh data sources?

       

      In addition, if your data sources are supported to set trigger refresh, you can try this:

      PowerBI RS: Setting Data Refresh in Trigger Mode | by Davis Zhang | Towards Data Science.

       

       

      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
        Icon for Helper I rankHelper I
        4 years ago

        1. I have tryed many types of data sources - mainly we use MS SQL, but i have a test reports -  with Excel source and one with Web page:

        None of them works! 

         


        I will try this trigger method, but i wanted to use the standart one. Unfortunetely i got this error.