Forum Discussion
report not refreshing from schedule refresh
Hi, I've got on onpremises gateway, i schedule the report to run at 9am everyday. I've checked the logged it successfully ran at 9am. But when i go into the report, the data is not ref...
- Hi there
Yes all the Power BI Servers are set to UTC, so when you using NOW() it is based on UTC time, and if you are in NZ that would mean it would be yesterday for most of the day.
I would suggest offsetting your data with =NOW()+12 which should make it 12 hours later when the dataset refreshes.
Hi there
It should work from the scheduled refresh
I would have a look at the logs in the Power BI Gateway and see when you click refresh what the logs are saying with the dataset refresh.
It should work from the scheduled refresh
I would have a look at the logs in the Power BI Gateway and see when you click refresh what the logs are saying with the dataset refresh.
hi,
are you refering to this log ? Which one do i look into ? Thanks
- Hi there
Yes all the Power BI Servers are set to UTC, so when you using NOW() it is based on UTC time, and if you are in NZ that would mean it would be yesterday for most of the day.
I would suggest offsetting your data with =NOW()+12 which should make it 12 hours later when the dataset refreshes. I got the same problem. Havent resolved it yet either. Are you on the latest version of Gateway? I am on North Europe region. What about you?
Hi,
The data refreshed but its yesterday report '25th June', Today's report should be yesterday '26th' instead.
So i'm thinking is it because i have something like =now()-1.
Is it because of 'timing' issue with my region (new zealand) vs 'USA. which is still a day before when the report is schedule to run ?