Forum Discussion

KylePerkins's avatar
KylePerkins
Frequent Visitor
3 years ago

Persistent issue: refresh is disabled because at least one data source is missing credentials.

I have a PowerBi report published to service connected to several data sources housed on Sharepoint that throws this error every time I want to refresh the report. The only means I have for refreshin...
Need Help
GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi KylePerkins 

 

Could you post the actual error to help troubleshoot?

KylePerkins's avatar
KylePerkins
Frequent Visitor
3 years ago

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.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 2f9e43dc-7c6d-46a8-a5bf-4b4bfacfeb11
Request ID: af97ff4c-6a27-1b2f-e34b-b0ae3043ac86
Time: 2023-02-16 22:56:10Z

  • KylePerkins's avatar
    KylePerkins
    Frequent Visitor
    3 years ago

    And when I follow these directions, I actually can't access the Data Source Credentials in the settings tab. 

     

    • GilbertQ's avatar
      GilbertQ
      Super User
      3 years ago

      Hi KylePerkins 

       

      You have to expand the Gateway connection which will then enabled the data source credentials.

       

      And then from the error you should be able to update your credentials for your data source.

      • KylePerkins's avatar
        KylePerkins
        Frequent Visitor
        3 years ago

        I'm not familiar with that operation. Here is what I see under my Gateway drop down in settings.