Forum Discussion

pratafran's avatar
pratafran
Helper III
4 years ago
Solved

omit 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...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Familiarize yourself with the try ... otherwise ...  pattern in Power Query

lbendlin's avatar
lbendlin
Super User
4 years ago

Familiarize yourself with the try ... otherwise ...  pattern in Power Query

pratafran's avatar
pratafran
Helper III
4 years ago

Thank you very much for your suggestion!, that allowed me to refine my research in google and find a solution.

Below a link to a video which explains with an example, exactly what I was looking for.. the solution was with the "Try ... otherwise ..." statement

 

On minute 6:50 the example for my case:

https://youtu.be/V4jQ34ujJ9g