Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
4 years ago

How to report on refresh errors

Hi , does anyone know if there is a way that I can report on all the datasets across all my workspaces to see if the daily refresh was successful or weather there was a refresh error.  

 

 

 

thank you

Richard

 

Need Help

2 Replies

  • Strangers's avatar
    Strangers
    Frequent Visitor
    4 years ago

    Try to use this query

    SELECT *
    FROM ExecutionLog3
    WHERE [TimeStart] > DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
    and [Status] <> 'rsSuccess'

    • cottrera's avatar
      cottrera
      Post Prodigy
      4 years ago

      Hi thank you for responding so quickly. It looks like I made a mistake and posted on Report Server and not on Service.  Appologies 

       

      Richard ğŸ˜€