When adding a datasource to a gateway, allow the 60 second timeout to be changed

[jfenico1]

When adding a datasource from my on-premise MySQL database, Power Bi will send a query to my Information.Schema table that can take over 60 seconds to query (depending on the database). Since it keeps timing out, I am unable to add the datasource which prevents me from setting up scheduled refresh times. It would be nice to either have the option to change this timeout interval or change the default query Power Bi makes to my database.

[eric_pieters]

'We ran into the same issue. I believe both are needed: - limit the query to just the requested schema (In desktop this where-clause is added when you add a MySQL datasource) - provide a parameter to adjust the Command TimeOut.