Skip to main content

    Power BI

    Needs Votes

    Direct connect to mysql database (not on premises) from Power BI (web)

    Vote (21) Share
    j.dijkman's profile image

    j.dijkman on 26 Aug 2016 21:43:14

    Next to the connections to Azure SQL databases, SQL Server analysis services (via Get Data -> Databases) etc., I would like to make a direct connection to a MySQL database (not on premises). In this case there is no need for the Gateway on premises (and server/computer).

    Does anybody now a good temporary workaround to keep the hardware in the cloud (nothing on premises)?

    Thanks!

    Comments (2)
    j.dijkman's profile image Profile Picture

    Patricia on 05 Jul 2020 23:05:29

    RE: Direct connect to mysql database (not on premises) from Power BI (web)

    I'm nearly done creating a pilot report for a client and I'm astonished to find this to be a roadblock. Please do something about this.

    j.dijkman's profile image Profile Picture

    Dion Vansevenant on 05 Jul 2020 22:45:47

    RE: Direct connect to mysql database (not on premises) from Power BI (web)

    Please add the ability to connect to MySQL databases to all levels of PBI (Desktop or Online) without the need for the gateway. It's very frustrating to create a beautiful report in PBI Desktop, Publish it to PBI Online, and then have to manually refresh and republish from the Desktop to get updates.