Forum Discussion
Helper IIHow to relieve pressure on MySQL, use Dataflow as an intermediary?
I'm having trouble with MySQL, I believe that because I have a lot of Applied Steps in Power BI, which is causing the MySQL server to be overworked, and I have many errors when refreshing.
If my hypothesis is correct, my thought is to use Dataflow as an intermediary, just import the MySQL data into a dataflow, and then send it to PowerBI Desktop and do my changes that I need. Would this reduce pressure on MySQL?
When I tried just making a dataflow with all the steps in the dataflow, I got the same errors, which is why I thought maybe having a dataflow with no applied steps would help.
There may be a slight delay between MySQL and the report updates, depending on the Dataflow refresh frequency. If that’s not an issue for you, this approach should work well.
Hi dinoscool3 ,
Utilizing Power BI Dataflows as an intermediary can help alleviate this pressure, but the effectiveness depends on how you implement them.
Heres a link that would help you start with the process.
How to create a Data Flow
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank You!
3 Replies
- mh2587
Super User
There may be a slight delay between MySQL and the report updates, depending on the Dataflow refresh frequency. If that’s not an issue for you, this approach should work well.
v-sdhruvCommunity Support
Hi dinoscool3 ,
Utilizing Power BI Dataflows as an intermediary can help alleviate this pressure, but the effectiveness depends on how you implement them.
Heres a link that would help you start with the process.
How to create a Data Flow
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank You!- v-sdhruv
Hi dinoscool3 ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You