Refresh Problem Across all Datasets / Workplaces

[ShrimpCreole]

I am having a persistent refresh problem across all my workplaces.  All my databases are in Excel and on my desktop.  Is there a simple solution or something I am everlooking with permissions?

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-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 5660b1ed-af97-4e90-be1f-00528803563d
Request ID: 84c70b1e-b5bc-4b16-f8e4-533430627516
Time: 2022-09-22 14:09:50Z

[AbbasG · Accepted solution]

@ShrimpCreole 

Make sure you have installed Personal gateway and it is signed in at the time of schedule refresh (If your data sources are on the local desktop).

Also, go to the dataset settings ==> data source credentials and update the credentials before refreshing it again.

Hope this helps 🙂

[lbendlin]

All my databases are in Excel and on my desktop

Databases?   Do you mean data sources?

On your desktop?  So you need to use a personal gateway? In the dataset settings make sure the gateway is selected, and that the credentials are all specified.