Power BI refresh continue if one query fails

[des_san]

Several of my power bi datasets (semantic models) have multiple queries. If one of the queries fails, the entire dataset does not update. Is it possible to have the dataset refresh the other queries even if one query fails to refresh?

example, one semantic model / dataset has:

Query 1, data source changed and a field/column header was renamed, this triggered an error during refresh.

Query 2, data source updated with new records. No error on refresh.

Goal: if query 1 fails, send alert to owner, and continue with query 2 refresh.

Currently, in the example above, the owner receives the alert that the dataset failed to refresh and points to query 1 field. The dataset does not refresh and remains cached from the last refresh.

[cassidy]

No, but you can create Dataflows for each Query and then have your Dataset use the Dataflows instead.  If a Dataflow fails, you will be alerted and it will simply remain showing the last successful query data.  The Dataset will not be impacted by Dataflow fails.

This is how I run my large Datasets that absolutely cannot fail, I much rather deal with a Dataflow failure than a Dataset.

[des_san]

Thank you for the suggestion. I haven't tried dataflows before but will certainly look into it.

[aj1973]

Hi @des_san 

Good suggestion from @cassidy , just be aware that with Pro license you can't refresh more than 10 Dataflows across Workspaces 

[cassidy]

Of course, Dataflows are probably my favorite Power BI tool.  Great for staging queries on a schedule and making them available to use across multiple Datasets.