Azure Synapse analytics connectivity with Tableau

Question

I have created server less synapse analytics with database and table in it.

I have tried using the SQL query to view data with in synapse analytics and can view it as expected but when I try to connect Tableau desktop version 2020.2.9 (as connector is only available in version 2020.2 and above) with connector provide in tableau the connection establish successfully as I can see the list of database and tables in it but when I try to click on the table to view data below issue pop-up.

An error occurred while communicating with Azure Synapse Analytics Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. Error Code: 2F0F5E42 [Microsoft][ODBC SQL Server Driver][SQL Server]External table 'dbo' is not accessible because location does not exist or it is used by another process. The table "[dbo].[Diagnosis]" does not exist.

Thanks, Roshan D

Answer 1

等待大神答复