jfenico1's avatar
jfenico1
New Member
8 years ago
Status:
Needs Votes

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

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.

3 Comments

  • Yuto_Watarai1's avatar
    Yuto_Watarai1
    Icon for Microsoft Employee rankMicrosoft Employee

    This scenario still exists. With "Skip test connection" turned on, the connection is created and semantic model refreshes succeed, but the test connection itself times out. A configurable test connection timeout would let us confirm that the data source is actually reachable.

  • '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.

Recent ideas