Is it possible to get data from an Azure MySQL DB without connection string and password?

[dgualandris]

Hello,

I need to get some data from a MySql Database hosted in a cloud Azure.

Since the database cannot be exposed over the internet, I need to log in with my Microsoft account that has the reading permission on the database (i cannot provide the host name, the username and the password).

I see this is possibile for PostgreSQL and SQL database but i dont't find the option for MySQL.

Does someone know a way to do this?

Thank you,

[v-henryk-mstf · Accepted solution]

Hi @dgualandris ,

In PowerBI, connecting to MySql requires an additional connector and the input of corresponding credential information, and its biggest limitation is that it can only be accessed through the power BI desktop.

But to connect to sql database in Azure, you only need to create the database correctly in Azure and enter the server name in the desktop to connect.

You can refer to related documents:

Connecting MySQL to Power BI: A Comprehensive Guide (hevodata.com)

Power BI Get Data: From Azure SQL Database - RADACAD

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.