How to relieve pressure on MySQL, use Dataflow as an intermediary?

[dinoscool3]

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.

[mh2587 · Accepted solution]

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-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

[v-sdhruv · Accepted solution]

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!

[mh2587 · Accepted solution]

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.