Forum Discussion
Refresh doesn't work
Hello, I need a help with the refresh.
I have a dashboard and when I click on refresh it, doesn't run.
But when I cancel the refresh and try again:
it works. I need to update at first time.
Anybody can help me?
Thanks a lot!
4 Replies
What happens if you refresh each individual table? Right click on a table and select "Refresh data". See if there is one table that is giving you problems.
When I update individually it works, but when I go to refresh all again, doesn't work.
Do you can help me?
How long are you waiting when you do a full Refresh? Is it significantly more than the sum of the individual refresh times? Example: 10 tables at 1 minute each, but full refresh is still spinning at 30 minutes.) Does one of the individual table take a lot longer than the others? Example: 9 tables at 1 minute each and 1 table at 10 minutes.
If so, can you disable the refresh of that one table temporarily and see if that helps?
(In Power Query, right click on the query and de-select "Include in report refresh") You don't want to publish it like that so set it back before publishing.
Basically, I am trying to get you to isolate one table that is causing issues, if you can.
