Power Platform Community Forum Thread Details

Hi,

Im trying to connect to Azure MySQL table.

I can see Insert row for SQL server identifies my server and my database. However, it is showing below error and not listing my tables.

The dynamic operation request to API 'sql' operation 'GetTable_V2' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "status": 401, "message": "Microsoft SQL: Cannot open server \"bla.bla.au\" requested by the login. The login failed. clientRequestId: 5195b4a0-06c8-4b86-b050-1faa244e9d61", "error": { "message": "Microsoft SQL: Cannot open server \"bla.bla.au\" requested by the login. The login failed." }, "source": "sql-ae.azconn-ae-001.p.azurewebsites.net" }