Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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-...
Solved! Go to Solution.
Thanks for assisting.
I've just tried and it doesn't work.
Thanks
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 ?
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,
are you refering to this log ? Which one do i look into ? Thanks
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 ?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.