topic How to report on refresh errors in Report Server

How to report on refresh errors

cottrera — Fri, 27 May 2022 06:31:45 GMT

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

Re: How to report on refresh errors

Strangers — Sat, 28 May 2022 15:43:19 GMT

Try to use this query

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

Re: How to report on refresh errors

cottrera — Mon, 30 May 2022 05:35:12 GMT

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 😀