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

[KylePerkins]

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 refreshing the data is to 1. refresh locally on Desktop 2. republish to service. I have re-entered my credentials numerous times, only to find this error persists when I try to refresh through service. 

Other users than myself update the underlying data sets (csv files) in a common sharepoint folder to which the powerbi report is connected via web link. Could this contribute to this error?   

[GilbertQ]

Hi @KylePerkins 

Could you post the actual error to help troubleshoot?

[KylePerkins]

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]

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

[GilbertQ]

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]

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