Solved: Refresh Problem Across all Datasets / Workplaces

ShrimpCreole · ‎09-22-2022

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 · ‎09-23-2022

@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 🙂

Future Super user 🙂
Data analysis resources on my youtube channel

View solution in original post

AbbasG · ‎09-23-2022

@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 🙂

Future Super user 🙂
Data analysis resources on my youtube channel

lbendlin · ‎09-23-2022

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.