Forum Discussion
How to connect Power BI to QPR AWS RDS SQL tables
I encountered issue to connect to QPR AWS RDS SQL tables via Power BI.
I have tried out several ways but it doesn't work. Which connection should I use?
I have following details:
Server: xspw62f622s
Database name: pmp2-prod-emea
Full address: pmp2-prod-emea.cq70rb3s2rvw.eu-west-1.rds.amazonaws.com
Port: 1433
and the credentials I used is a PAM service account, which I use Alternative windows credentails on PBI.
when I tried to use MySQL connector:
when I tried to use SQL Server connector :
Appreciate for your help, thank you in advanced!
2 Replies
alice11987 , Hope you have opened port access from RDS.check the security group rules and ensure that your Power BI computer is allowed to connect to the instance
refer: https://wci-consulting.medium.com/how-to-connect-power-bi-to-an-aws-rds-sql-server-a70b0229f280
https://www.youtube.com/watch?v=L5x_gnimz04
https://www.youtube.com/watch?v=fZV1VSRF0Zg
Hi alice11987 ,
This is the related document, you can view this content:
Mysql Error:
Re: Unable to connect MYSQL | Details: "MySQL: Una... - Page 2 - Microsoft Power BI Community
unable to connect to mysql - Microsoft Power BI Community
c# - MySqlException: Unable to Connect to any of specified MySQL hosts - Stack Overflow
SQL Server Error:
Solved: Server error "Error Message: A network-related or ... - Microsoft Power BI Community
Solved: Error 2146232060 - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
