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-...
Go to Solution.
Thanks for assisting.
I've just tried and it doesn't work.
It tried to refresh but nothing really happens.
Still no new data.
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 ?
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.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!