Forum Discussion

Helper I

5 years ago

Data Refresh has suddenly stopped working

Hi, Today i recieved a number of notifications that my reports have stopped refreshing automatically with the following message "Data source error: Scheduled refresh is disabled because at le...

Helper I

5 years ago

Thanks GilbertQ for you response

Yes I can refresh ok via Desktop and also manually in the service.

Thanks again

GilbertQ
Super User
5 years ago
Hi SuperCal99

What happens if for the datasource you try the Skip Connection test?
- SuperCal99
  Helper I
  5 years ago
  Hi GilbertQ
  
  Still no luck with that
  
  The other data sources I have in other reports seem to work ok, such as Google Analytics and an Excel spreadsheet in my business One Drive account.
aj1973
Community Champion
5 years ago
Hi SuperCal99
Why do you think you don't need a Gateway? and how is possible that you can refresh it manualy in the service and not Automatically!
- SuperCal99
  Helper I
  5 years ago
  Hi aj1973
  
  Thanks for your response
  
  Gateways arent needed if all the data sources are in the cloud? I hadnt set them up previously and it also states the following under gateway settings in the datset settings
  
  You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect
  
  Forgive me, its NOT working when I manually refresh the data in Service, but it is when in Desktop"refresh now"
  
  Thanks,
  
  Callum
  - aj1973
    Community Champion
    5 years ago
    SuperCal99
    Ok now is different when say that the refresh doesn't work in the service, was kinda confusing!
    try to change the connection string from anonymous with a privacy to anonymous with Public
    both in desktop and service
    I am sure it is the connection string.