Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm using an EC2 container to host Microsoft Windows Server with Power BI Desktop and Gateway installed. The report I'm working with is pulling from MySQL hosted on AWS RDS under the same VPN.
Using the desktop report builder, I'm able to pull the data from MySQL using DB credentials generated by IT. However, after following the directions in the Enterprise Gateway setup documentation, I'm getting "The credentials provided for the MySql source are invalid," even while using the exact same login info and server host/DB as the report builder. The password comes from a copy/paste in a text file, so it's extremely unlikely that I'm just entering it incorrectly (and I've even tried typing it manually just to make sure). All settings (privacy level, encryption) are set exactly the same.
I've also set up another web data source based on a REST API being hosted under the same VPN to confirm that the Gateway works correctly, and I'm able to set up the connection online.
Is there anything else that could be causing an auth error? I'm not going to rule out the possibility of incorrect credential entry 100% (you never know), but I've tried just about everything now and I want to make sure.
Thanks for your time!
This may be a bit of an off question but are you using the MySQL ODBC driver? If yes, which one, official or Simba?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.