SSMS select * from a PowerPlatform connected database produces an error

Copper Contributor

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?



0 Replies