Forum Discussion
report not refreshing from schedule refresh
- 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.
desktop works. And shouldn't it be looking at the same source already since if i manully click refresh on powerBI service the dataset would be refresh ?
If you would like it to refresh you would need to right click on the dataset and then click Refresh Now
By clicking the Refresh button in the Power BI Service that simply refreshes the cache.
- 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 Gilbert,
I understand you. And yes the manually updating dataset works.
However, i want it to 'automatically' update the dataset instead of me right clicking the dataset and refresh.
Thanks
- 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. hi,
are you refering to this log ? Which one do i look into ? Thanks
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 ?