What we are going to show below is when you upload an existing Power BI File into the Power BI Service, if you have an existing scheduled refresh via the Power BI Enterprise Gateway, that it modifies your scheduled refresh.

Current Scheduled Refresh scenario

  1. To start off with I will show you before I upload a Power BI Desktop file when it is set to run via a scheduled refresh
  2. As you can see from above it is set to run at 13:00
  3. Now after I upload my file, with it changes into the Service, I click on the ellipses for my dataset and I see the following:
  4. As you can see from above I uploaded the file at 12:32:22 which was the last time the data was refreshed.
  5. But now on the second line the Next refresh is set to 23:00
  6. And when I go and have a look under the Settings, then Datasets it currently has got the Schedule Refresh as shown below:
  7. As you can see from above the next refresh should be at roughly 13:00
  8. And to confirm that it is using the Enterprise
    Gateway
  9. In the next steps I will show how to quickly resolve this.

How to fix or resolve the Scheduled Refresh

  1. Go into your settings and click on your Dataset
  2. Then under Schedule Refresh, click on the button which says Keep your data up to dateYes as shown below:
  3. Click on the button to disable it so that once done it looks like the following:
  4. Then either scroll down and or click the Apply button as shown below:
  5. Once you have clicked Apply it will show the following to show that it is successful
  6. The good thing is that it still keeps your existing schedule.
  7. Now all that we need to do, is to re-enable the schedule refresh to get it working again by doing the following:
  8. Then under Schedule Refresh, click on the button which says Keep your data up to dateNo as shown below:
  9. Click on the button to enable it so that once done it looks like the following:
  10. Then either scroll down and or click the Apply button as shown below:
  11. Once you have clicked Apply it will show the following to show that it is successful
  12. Now when you go back to your Dataset and click on the Ellipses button you should now see that your scheduled refresh will refresh as expected.
    1. As you can see from above the last refresh date and time is the same, but now the Next refresh is for 13:00

Leave a Reply

Your email address will not be published. Required fields are marked *