Skip to main content

    Power BI

    New

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

    Vote (5) Share
    Justin Fenico's profile image

    Justin Fenico on 06 Mar 2018 23:14:24

    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.

    Comments (1)
    Justin Fenico's profile image Profile Picture

    15eb4ec9 deae-4f85-9b8a-09d7f0817cb1 on 05 Jul 2020 23:17:22

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

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