How to skip failed dataset on refresh?

[Anonymous]

Hey guys, I have a big data model with 2 major external data sources, and we do scheduled refresh in Power BI Desktop.  Recently one of the data sources is not stable and we saw timeout error message sometimes.  But what makes me frustrated is when one of the data source refresh fails, it fails the whole refresh process and showing 'Load was cancelled by an error in loading a previous table' message, even other sources have been successfully refreshed.  I understand fail to refresh the particular dataset could make part of the data in the model stale, but we can accept that, and hope we can skip the error and let the rest of the data model be refreshed.  Does anyone know is there any setting available in Power BI Desktop to skip the failure of particular data source on refresh and update rest ones?  Thanks!

[V-lianl-msft]

Hi @Anonymous ,

You can try uncheck the potion:

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vojtechsima]

Hi, @Anonymous 
if you have 2 major external data sources and you primarily update them and then the rest of it, you can create those as Dataflows and then add the dataflow into your reports like you would normally do.
Then if the dataflow refresh fails, the reports that take information from the dataflow should be refreshed with last available data.