CODEWITHSUNDEEP
amazon-ec2powerbi
Fahim Akhtar
Fahim Akhtar

Reputation: 61

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.?

Upvotes: 3

Views: 7869

Answers (3)

Nan Yin
Nan Yin

Reputation: 41

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: input IP and database name

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

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

Upvotes: -1

Masayuki
Masayuki

Reputation: 189

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

Upvotes: 0

Sjoelbakje
Sjoelbakje

Reputation: 33

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

Upvotes: 2

Related Questions