SQL connection staying open

Power Query
1

I get data from a MySQL database using a SQL query. I’ve notice in Power BI whenever the query is run in MySQL, the query gets opened in SQL but it does not close the query again. Should I run the same query in MyuSQL the query opens and after it has run, it closes the query.

Is there a way to get PoweBI to close the query?

2

@NicoS Why do you want to do that?

3

There is a limit on the number of open connections and it slows down SQL

4

Power BI runs the same query multiple times and opens a connection to the server every time. If I run a query in SQL it opens a connection, runs the query and closes the connection on the server. Power BI opens the connection and runs the query. The connection is not closed afterwards.

5

Bumping this post for more visibility from our experts and users.

6

Hi @NicoS - Don’t think Power Query has any such capability to close the SQL connection. @Melissa - Is there any such option possible

Thanks
Ankit J

7

Hi @ankit,

No, I am not aware of such an option.

8

Thanks for the reply.