Forum Discussion
Scheduled Refresh Succeeds but Data Won't Update
spinachbisque How quickly are you checking the report after the dataset has said it has refreshed? The Dataset, Report and dashboard are seperate objects and are not all immediately refreshed after the dataset. It is in order. If the dataset refreshes, it is likely it will be 10-15 before the report, and then the Dashboard. You can also initiate a refresh in the report after the dataset.
If you know, and or tried the above, then this sounds like a bug or issue that you should raise in a support ticket or the issues page.
Advocate IHi, I'm also experiencing the same issue.
I have two reports in a workspace and their associated datasets both use the same gateway to two different databases in the same SQL Server instance.
The datasets for both reports indicate that they have refreshed at the scheduled time. However, whilst one report shows the refreshed data, the second report does not, even if I click the report refresh button.
Similarly, clicking the 'Refresh now' action within the Datasets list has no effect.
I have tried republishing the report, which works for that day but then fails to refresh the following day. I have deleted the reports and associated datasets and even deleted the Gateway but to date, none of these attempts have succeeded in resolving the issue.
Any input or advice would be appreciated.
Karl
Hi Karl,
I am experiencing the same issue trying to connect to two databases with one gateway.
Have tried a workaround using a view which doesn't fix anything - have you managed to solve the issue?
Joshua
- ims20180411kjb
Not yet unfortunately Joshua. I'm still awaiting further contact from the support team who were attentive initially but now appear to have disappeared and are not replying to my emails.