Forum Discussion

4 Replies

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    4 years ago

    There are not a lot of options in this area. But it depends on what problem you are trying to solve or what errors you are getting as to what the possible solutions or workarounds might be. Can you give us more details on the problem you are trying to solve?

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    For your description, I think you can use the following PowerShell functions to refresh the powerbi report hosted on the powerbi report server.

    1. Get-RsRestCacheRefreshPlan
    2. New-RsRestCacheRefreshPlan
    3. Start-RsRestCacheRefreshPlan

    This allows you to create (new), get and start cache refresh schedules for Power BI reports deployed to PBIRS instances. For clarity, these only apply to reports that use the import model and not to reports that use direct queries.

    Depending on your application scenario, refer to the following links for details.

    GitHub - microsoft/ReportingServicesTools: Reporting Services Powershell Tools


    Best Regards,
    Henry


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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Henry,
      How can we setup hourly refresh plan on PBI report server using 'New-RsRestCacheRefreshPlan' function in Powershell

  • schueppi's avatar
    schueppi
    New Member
    4 years ago

    I tried New-RsRestCacheRefreshPlan but the 'Internal Server' returns 500 error. I use Power BI Reporting Server with a import model. Data are imported from a MS SQL Server 2014 Express Edition without SQL Server Agent. Are there any other conditions that New-RsRestCacheRefreshPlan works properly?