Forum Discussion

Till's avatar
Till
Resolver II
4 years ago

Power bi dataflow and Premium Capacity

Hi All,
Since a few days we have connected two reports for testing with dataflows. These dataflows have an SQL source and are updated every hour via Power Automate. The report is also updated hourly via Power Automate. There are a total of 8 dataflows that flow into the Power BI report.
Now we have noticed that our P1 node is increasing in load per hour.

No incremental data update is set.
In the following figure we have the same reports only in different APPS. They are all updated from the same dataflow.
Does anyone have an idea why the load increases from hour to hour?

 

Kind Regards


 

Dataflow
Need Help

3 Replies

  • collinq's avatar
    collinq
    Super User
    4 years ago

    HI Till ,

     

    Without truly getting into all the gory analytics on your site, I am curious - do you think that any of the flows are still runnign while other ones are starting?  I know that this happened to me once - we had a flow run much longer than expected and that made the other flows compete for resources (and the exact same data source in some cases).  In fact, we ended up getting failures, rather than just an increase in usage.  Might this be happening to you?

     

    • Till's avatar
      Till
      Resolver II
      4 years ago

      Hi collinq 
      Thank you for your answer.
      That could be the reason.
      I will fine-tune the flow update so that overlaps are avoided.
      I will report back after the test.
      Kind Regards
      Till

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Till 

    Have you solved this question with collinq's help? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

    If you need more help, please let me know.

     

    Best Regards,

    Community Support Team _Tang

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