Managed Databases and Reporting on AWS / Microsoft

I am currently trying to analyze some data that I have on the managed MySQL database service. However trying to connect through either power bi / aws quicksight has been a real headache.

  • Connecting through power bi on Windows desktop out rightly fails. This is with the correct login details.

  • Connecting through quicksight outrightly fails with ssl enabled and soft fails without ssl enabled. The error without ssl enabled is Public Key Retrieval is not allowed.

Could someone kindly clarify on if it is possible to connect these 2 to a managed database on digital ocean?

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hi Christiangumo

Are you having issues to connect to Power Bi Desktop? this is what I did.

From Get Data select MySQL database, click Connect.

On field ‘Server’: add your host address and port:

On field ‘Database’: add database name.

when prompted to add your credentials, select ‘Database’. Enter user name and password and you should be good to go.