Forum Discussion

des_san's avatar
des_san
Icon for Advocate I rankAdvocate I
2 years ago

Power BI refresh continue if one query fails

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 ...
Need Help
cassidy's avatar
cassidy
Icon for Power Participant rankPower Participant
2 years ago

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's avatar
des_san
Icon for Advocate I rankAdvocate I
2 years ago

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

  • cassidy's avatar
    cassidy
    Icon for Power Participant rankPower Participant
    2 years ago

    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.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi des_san 

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