Probably you have two or more distinct tables with the same name in different schemes, I got exactly that error message and I discovered that was the problem

You can check for limitations here https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql#requirements-and-limitations