We have connected our PowerPlatform CRM database to SSMS as follows:
When right clicking on the Accounts ( or any other object within this connected database) as follows:
, or when we type select * from Accounts we get the following error message:
When we manually type the fields in like:
Select accountId, territorycode from dbo.account it works correctly.
How do select all columns or without getting this error message?