Forum Discussion

vsslasd2200's avatar
vsslasd2200
Copper Contributor
May 08, 2023

SSMS select * from a PowerPlatform connected database produces an error

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?

 

 

No RepliesBe the first to reply

Resources