Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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.
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?
Proud to be a Datanaut!
Private message me for consulting or training needs.
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.