Forum Discussion
pratafran
Helper III
Helper IIIomit backbround refresh if database error
Hello, I have a Power BI on premise with around 20 different datasources in import mode and background refresh every 30 mins. I'm adding a new connection to my model from an SQL server with a...
Familiarize yourself with the try ... otherwise ... pattern in Power Query
pratafranHelper III
Helper IIIThank you,
If I exclude the table from report refresh, It will never refresh. What I'm looking for is to add a kind of conditional to that function. IF the database returns error when refreshing, omit the refresh, otherwise, refresh the content of that connection.
The problem arises with the inestability of a particular connection that I want to avoid stopping the refresh of the whole BI since it is only a dictionary that if it doesn't update, it is not a big issue.
