Forum Discussion

jeggert's avatar
jeggert
Frequent Visitor
8 years ago
Solved

Refreshed Data Sets not staying Refreshed

  I upgraded to the October PBI Report Server earlier this week.  We have recognized that PBI reports with embedded models do now refresh on a schedule (wahoo! yay!); however, the report seems to re...
Data set
October GA
Refresh
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi jeggert,

     

    What do mean about "however, the report seems to revert back to the as-first-uploaded version of the data some time after the scheduled refresh"? Is there any error message throws out about refresh? 

     

    You can follow this article to troubleshooting the issue: Troubleshoot scheduled refresh in Power BI Report Server.

     

    Best Regards,
    Qiuyun Yu

AdamF's avatar
AdamF
Helper I
8 years ago

irvmic and PhilA87 - have you tried increasing the ModelExpiration minutes per jeggert's post? It is not foolproof but it generally seems to keep the refreshed model up to date.

 

wrote:

Thanks.  I have set the ModelExpirationMinutes sufficiently long (to 525600 - a year in minutes) and it's working as expected now.  The AS models that fed the PBI pages were getting ejected from memory according to the default setting of 60 minutes.  For our use case, we update the data warehouse overnight, and we update the PBI data sets every morning.

Another thing I found to be aware of is that the refreshed AS models do not reload after a server reboot.  The PBI model refreshes need to be manually triggered (or wait for regularly-scheduled morning refresh). 

 

pygmysog's avatar
pygmysog
Frequent Visitor
8 years ago

Thanks Adam. I figured my problem is not about the model expiration but the data gataway. It uses my personal mode but still keeps failing due to various reasons. I'm applying for additional access to see if it'd work.