Forum Discussion

GLWY's avatar
GLWY
Frequent Visitor
2 years ago
Solved

PBI Desktop query caused issues in Power BI Service

Hi,   We recently encounter a very intersting issue. On Monday, our Power BI Service went down for about 2 hours and nobody could run a report. We investigated and found that the throttling % went ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    My question is, is there a way to update all reports in Power BI service and set them to Auto? so that we don't end up with this situation again

    no, there is not.  This is not your only issue though. Keep in mind that dataflow refreshes also do not have any duration timeouts. A single rogue dataflow can bring down your entire capacity for a long time when it completes.  We have now setup a monitoring process to automatically cancel all dataflows that run longer than five hours. It's not foolproof though as cancelation requests may or may not be honored by the Power BI service.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
My question is, is there a way to update all reports in Power BI service and set them to Auto? so that we don't end up with this situation again

no, there is not.  This is not your only issue though. Keep in mind that dataflow refreshes also do not have any duration timeouts. A single rogue dataflow can bring down your entire capacity for a long time when it completes.  We have now setup a monitoring process to automatically cancel all dataflows that run longer than five hours. It's not foolproof though as cancelation requests may or may not be honored by the Power BI service.