Problems with data update

[jesuslogmein]

Hello!

We work with PBI with premium capabilities.

We have reports in a work space with scheduled updates every 30 minutes.

The problem is that they are connected to a DB that updates every 30 minutes. This DB takes 5 minutes to finish loading.
The scheduled update of the report takes less time than it takes my DB to finish loading and therefore we don't see all the data in the report because the updates overlap.
E.g.

My DB updates at 9.30h and takes 5 minutes to load data.
My report updates at 9.30h and takes 3 minutes to finish updating, there is a difference of 2 minutes and we lose data.

How can we solve this? We can't delay the GDP update to another time slot.

Is there any way to control the scheduled update time and instead of scheduling it at 9.30/10.00/10.30 put it at 9.40h/10:10/10.40?

[lbendlin · Accepted solution]

Absolutely.  You can initiate dataset refreshes from Power Automate.  Power Automate has its own scheduler. 

Alternatively you can do this from Powershell and use the standard Task Scheduler  (if you have a PC or VM that is always on)

What would be even better is if your upstream system (the database) had a way to signal when it is done updating. You could then use that as the trigger for the refres hrequest - no scheduler required at all.