Forum Discussion
analystict
Helper I
Helper ILimiting Scheduled Refresh Errors
Dear all, I am experiencing an issue in which every time there is a schedule refresh and an error occurs in a specific table, the whole dataset refresh fails, even tables/columns which are not af...
- Hi there
The way the refresh currently happens is that it refreshes all the data.
Due to this when there is an error the entire refresh will fail even if there is one error.
As far as I know the one way you could modify this is in the Power Query editor, where you could ignore errors.
If it is based on columns you would have to create some complex Power Query to get it to ignore the error.
I would suggest ensuring that the source data remains as expected.
GilbertQ
Super User
Super UserHi there
The way the refresh currently happens is that it refreshes all the data.
Due to this when there is an error the entire refresh will fail even if there is one error.
As far as I know the one way you could modify this is in the Power Query editor, where you could ignore errors.
If it is based on columns you would have to create some complex Power Query to get it to ignore the error.
I would suggest ensuring that the source data remains as expected.
The way the refresh currently happens is that it refreshes all the data.
Due to this when there is an error the entire refresh will fail even if there is one error.
As far as I know the one way you could modify this is in the Power Query editor, where you could ignore errors.
If it is based on columns you would have to create some complex Power Query to get it to ignore the error.
I would suggest ensuring that the source data remains as expected.