Conne ting PowerBI to Azure MYSQL Database

[tim_goodsell]

Hi

I have a report which connects to an Azure MySQL database. This works fine within Desktop but when i publish it to the Power BI Service do i need an On Premise Data Gateway installed to refresh the data ?

[witczakp]

Hello All,

I have similar issue, I have Azure Database for MySQL flexible server, and on PowerBi Desktop report, everything is working ok, after installation of MySQL connector.. (only specific version works, not latest)

But it is not connecting to this database on Azure, after PowerBi report is beeing published..

Connection status is Offline, and in details window, I see error: 

Error codeDMTS_DatasourceHasNoCredentialError

Connection errorConnection has no credentials.

When I tried to edit connection it this window:

I see that login name and password are empty, when I fill them I can't save.. just nothing happens. On dev tools in web browser I see some errors..

I also tried to create new MySql connection, but.. then there is no MySql connector available in this window in Connection type dropdown..

Do You know if My SQL connection is even possible using https://app.powerbi.com/ ??

I'm stuck and I'm wondering to write azure function which will return all data base as Json.. but... I feel that is not good idea.

[powerbirt]

Hey Tim, what did you end up doing here? 
We have a Azure Database for MySQL that we connect to in PowerBI desktop. 
We've created a dataset and when we try to publish it and link the data source in the powerbi gateway settings it will not make a connection to the Azure DB. 
What did you do to end up getting this dataset published? If it's not requried to have a onprem data gateway for this - what is the way to do this? 

[AlexisOlson · Accepted solution]

You generally do not need an on-prem data gateway for cloud sources.

From this previous post:

If you are connecting to a SQL Server that hosted in Azure VM but not Azure SQL database. For the former, gateway is required, you should install gateway on the same machine, then add SQL Server data source within the gateway. For Azure SQL database, gateway is not required.