Forum Discussion

luciuslan's avatar
luciuslan
Frequent Visitor
8 years ago
Solved

Scheduled refresh issue

I'm currently facing the exactly same problem as per described in this post: https://community.powerbi.com/t5/Report-Server/Refreshed-Data-Sets-not-staying-Refreshed/td-p/301091

That the dataset within a report was successfuly refreshed, but revert back to the originally uploaded one, after finishing the scheduled refresh. 

I noticed that jeggert said configuring "ModelExpirationMinutes" as described in this link suggested by the microsoft guy, but I cannot find the configuration in SSMS or anywhere. Could you please elaborate on how to configure this, or is there any restriction to the data source that can have this configuration?

 

P.S. most of my reports use a SQL Server (on-prem) tables and views as data sources.

scheduled refresh
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi luciuslan,

     

    Connect to your server via SSMS - Server Type: Reporting Services, Server Name: http://YourReportServer/ReportServer.

     

    You'll find all configuration settings in Server Properties, Advanced page.

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi luciuslan,

     

    Connect to your server via SSMS - Server Type: Reporting Services, Server Name: http://YourReportServer/ReportServer.

     

    You'll find all configuration settings in Server Properties, Advanced page.

     

     

     

  • aedward1987's avatar
    aedward1987
    Regular Visitor
    8 years ago

    Hi, I am facing a similar issue. Could you let me know how you confgured the settings for ModelExpirationMinutes