cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drewburken Frequent Visitor
Frequent Visitor

mySQL random connections

When we open Power BI on the desktop client (PBIX file). It will automatically create a connection to the tables that are referenced in the file for some reason. Does anyone know why the connections start automatically issuing SELECT commands even if it has not been instructed to yet?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: mySQL random connections

Hi @drewburken ,

You can enter to query edit and turn off 'include report refresh' option to disable report loading update or switch to import mode.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

Re: mySQL random connections

HI @drewburken ,

I think you are working with direct query connection mode, right? If this is a case, power bi will try to update data source every time you interact with visual data or loading data model .

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
drewburken Frequent Visitor
Frequent Visitor

Re: mySQL random connections

Yes, we are using power query. Is there any way to turn this off?

Community Support Team
Community Support Team

Re: mySQL random connections

Hi @drewburken ,

You can enter to query edit and turn off 'include report refresh' option to disable report loading update or switch to import mode.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |