Forum Discussion

tim_goodsell's avatar
tim_goodsell
Frequent Visitor
4 years ago
Solved

Conne ting PowerBI to Azure MYSQL Database

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 refres...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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.
witczakp's avatar
witczakp
New Member
2 years ago

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.