Automatic refresh not working

[Anonymous]

I am having an issue with automatic refresh. Automatic refresh has failed many times I checked my refresh history and I saw it failed since last year and after deleting a one drive from the data set it still seems to be refreshing. I don't know why the one drive is still connected to the dataset. 

Please let me know if yall have a solution for something like this. 

I suspect it's a creditials issue but I am not sure whose creditials I need. The desktop SQL creditials are the same as Power BI Service creditials. 

data sources: 2 SQL servers

[collinq]

Hey @Anonymous ,

When you look at the fail log, it will tell you the reason that it is failing and which datasource is causing you the pain.  If you deleted a data source at some point, have your emoved it from the report and/or removed it from the report's gateway?  What does the error actually say?

[Anonymous]

The queries are all refreshing except for one query pulling the sql database.