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 refreshed with the latest info in SQL.
I've also tried manually push the 'refresh now' on the dataset.
It works alright with the latest data refreshed.
So i don't know why manually refresh dataset works but not schedule refresh ?
I have problem previously, i don't know if they are connected. The dataset failed to refresh due to incorrect numeric format, i've made the changes in 'Edit Queries'. Please take a look athttps://community.powerbi.com/t5/Service/Dataset-failed-to-refresh-Unable-to-convert-a-value-to-the-data/m-p/721957/highlight/false#M70558
- 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.
13 Replies
- Hi there
What happens if you click on the "Reset to Default" button?
I have seen instances where there is a filter that is causing the report to not display data correctly.- What happens if you do a CTRL + F5 on the page?