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.       ...
Need Help
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 ğŸ˜€