Forum Discussion

SuperCal99's avatar
SuperCal99
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 least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."

 

My data sourceconnection is a web URL, settings are anonymous with a privacy of none so no gateway required.

 

When i try to reconfigure the credentials as instructed, i recieve this message

"Failed to update data source credentials: Unable to connect to the remote server"

 

Any advice would be greatly appreciated

Need Help

10 Replies

  • SuperCal99's avatar
    SuperCal99
    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

      • SuperCal99's avatar
        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's avatar
      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's avatar
        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

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi SuperCal99 

     

    The error would indicate that your web source is no longer available.

     

    What happens if you try and refresh it manually via PBI Desktop does it get the data?