How to connect POWER BI web with AW mysql database

问题:

I am new to power bi , i need to connect my AW mysql database with power bi, i did research but did not find any suitable answer can any one help please.?

回答1:

I think you mean AWS mysql database?

There is no direct way to connect Power BI yet, you can see on the Power BI Ideas page, the idea is "under review": https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6809030-aws-rds-sql-server-data-source

Maybe you can use a BI application from the Amazon Partner list? https://aws.amazon.com/rds/partners/#Business_Intelligence

回答2:

You can use Power BI Desktop to connect with AWS mysql. This article describe how to connect mysql. After you connect mysql with Power BI Desktop, you can get and manage data.

In addition to it, if you want to see data in Power BI Service (web service), you can use Power BI Gateway with Power BI desktop. These enable your data sync automatically with Power BI Services. https://powerbi.microsoft.com/en-us/gateway/

thanks, masa

回答3:

I'm able to get access to AWS mysql database through Power BI desktop. Here is my steps:

1. input remote mysql server IP and mysql database:

2. input remote mysql username and password from Database Tab:

Then I'm able to get access to the remote database. Hope it helps.