Hi @Amar Agnihotri , welcome to Microsoft Q&A forum.
Continuing the discussion from previous issue, I am posting the reply here:
I think the issue here is, you are using Azure MySQL Database instance name as database which is different than database. One Azure MySQL Database can contain multiple databases. As an example your instance name is 'ids-bi.mysql.database.azure.com' but in this instance we need to create databases where we can connect and restore the backup from the dump.
Please find the workbench snapshot below. Here I connected to azure MySQL instance and then created a testdb database. Now same way you need to create database and specify the name in database field when configuring an endpoint in above screenshot: