Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Automatic refresh not working

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

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • collinq's avatar
    collinq
    Super User
    4 years ago

    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?