Limiting number of connections to mysql server

[Anonymous]

Hello,

Is there a way of limiting the number of connections that PowerBI will use when working with a MySql server?

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Currently, there are some methods provided in power bi that you may have a try.

1.

With the May release of Power BI Desktop you can now define incremental refresh policies for your models. At present these only apply once the model is published to a Premium workspace in the Power BI service.

You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh

2.

In Power Query, when you right-click on the name of a query (in the left-most pane of Power Query's window), you will see selections for "Enable Load" and "Include In Report Refresh."

"Include In Report Refresh" means query is automatically refreshed when you press "Refresh" button on the ribbon.

"Enable Load" means query results are available for report builder. Otherwise you may use it in your other queries (for example to merge data), but it is not shown in the report builder.

If you don’t want to refresh table1 of the dataset, you could turn off “Include In Report Refresh” for table1. Then when you refresh the button, it refreshes except table1.

3.

Some workarounds about Incremental load in PowerBI

Best Regards

Maggie

[parry2k]

@Anonymous can you explain the use case?

[Anonymous]

I am currentry using the live database of a website as workhouse for powerbi and when I refresh all data i'm drastically slowing down everyone elses reads/writes. And limiting the number of connections to the server so that it will take longer to refresh the data but the overall experience for others won't be affected seems like the logic solution for me, but I don't know if and how is that possible. @parry2k

[parry2k]

are you using direct query or import?

[Anonymous]

import @parry2k, i'm not sure that you have an option when it's a mysql server database , for the sql server database you do.

[itchyeyeballs]

Power BI refresh shouldn't dramatically impact a db unless there is something else going on.

How big are your datasets?
Are you sure you're queries are working correctly, no missing joins etc?

Is it feasible to create a second database for reporting and run an overnight procedure to sync with live db (assuming you don't need live data)?

[Anonymous]

The .pbix file itself is 500 mb. The datasets are probably around 20 gb. The problem is that almost all tables are somewhat connected and need to be used for filtering. So dividing the file would be a pretty hard task. @itchyeyeballs