This is essential. I'm surprised it hasn't yet been implemented considering the number of startups that use MySQL and may have come to Power BI through Office 365.
I can connect to RDS SQL Server by using SQL Server option and Direct Query. However a pro license is required when you "publish to web" from the desktop version.