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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
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

  • jeggert's avatar
    jeggert
    Frequent Visitor
    8 years ago

    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). 

    • 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.

    • AdamF's avatar
      AdamF
      Helper I
      8 years ago

      Is there any way to persist the refreshed data model, so that the data in the report stays updated even after it is removed from memory, e.g. after server reboot? It is confusing to users that the data can get reset back to its original version, and hard to get confidence that the scheduled refresh is working as expected.

      • dataviznz's avatar
        dataviznz
        Advocate IV
        8 years ago

        Can someone from the PBIRS team please confirm that this is really the case? Because scheduled data refresh not remaining 'refreshed' should be considered a (major) bug.