cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Limiting number of connections to mysql server

Hello,

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Limiting number of connections to mysql server

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

 

View solution in original post

7 REPLIES 7
Super User IV
Super User IV

Re: Limiting number of connections to mysql server

@Anonymous can you explain the use case?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Limiting number of connections to mysql server

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

Super User IV
Super User IV

Re: Limiting number of connections to mysql server

are you using direct query or import?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





itchyeyeballs Established Member
Established Member

Re: Limiting number of connections to mysql server

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

Re: Limiting number of connections to mysql server

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

Anonymous
Not applicable

Re: Limiting number of connections to mysql server

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.

Community Support
Community Support

Re: Limiting number of connections to mysql server

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

 

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors