Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
i have published a report to the service and set up a scheduled refresh. The report gets its data from SQL Server database. The dataset can refresh using the Data Gateway.
The scheduled refresh completes without any error. Scheduled and on demand refreshes are status 'completed'.
Unfortunately, the report only shows new data once I refresh the dataset manually by clicking 'Refresh now'.
I have set up a new data gateway with no success.
The problem is handled in the following link but as the solution does not work for many people, I have created a new thread:
https://community.powerbi.com/t5/Service/Scheduled-Refresh-Succeeds-but-Data-Won-t-Update/m-p/531699
Hi, I'm also facing the same issue in my scheduled refresh dataset refreshed successfully but the reports does not get updated.
And when i manually refreshed(Refresh Now) its got updated.
aEven I have the same issue, it is not reflecting in service while on desktop this looks fine, is it related to something Incremental Refresh.
Have you managed to find a solution? I too am facing a similar issue - scheduled refresh doesn't work (even though reflects successful completion) but manual refresh updates the data.
Hi everyone!
I noticed that in my setup the report showed up-to-date data on Mondays, as there was no new data on weekends. So I worked out that it worked whenever there were more than one refresh.
After adding a second refresh every morning it worked for me for every report. So I added e.g. one refresh at 1 AM and one at 1.30 AM.
Hi,
Still having this issue, tried several things but didn't work unfortunately..
(delete report and publish again, change the refreshing time)
Manual refresh is the workaround.
hi, @bentz
I have tested on my side, it works well. Could you try to browser cache and try it again.
If you could delete the dataset in power bi service and republish it again, and if you could update the gateway to the latest version.
If you still have this problem for Power BI, you'd better create a support ticket in Power BI Support to get further help. then share the result with us.
Best Regards,
Lin
Hi,
thanks for your response. The issue is not browser related. We have tried different browsers and machines.
Two things we have worked out:
1. It's the first refresh of the day that didn't work. The second works (no matter if manual or scheduled), so the subject of this thread is not accurate anymore.
2. I have created copies of the report and in each copy I have removed on of the SQL tables in use. One joined table seems to cause the problems. Once this has been removed from the report, it refreshes (on the first refresh of the day).
So, still no idea what the problem is really, but I found some workarounds.
I just installed the gateway today so I'm quite new to the whole data refresh thing.
I had the same issue and just wasted a few hours of unnecessary work.
Just to make sure you're not as "stupid" as I am.
I just realized that I have to hit this little "refresh" button and the visuals will actually be updated. My data will show correct then. If I don't do it, it doesn't.
Hope this helps at least someone 🙂
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
52 | |
45 | |
24 | |
24 | |
21 |