Forum Discussion
UBdev
Apr 07, 2023Copper Contributor
Getting error when dataverse connecting through MS SQL SERVER 2022
HI, I am getting error message TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) F...
LainRobertson
Apr 07, 2023Silver Contributor
This isn't really the correct place to ask about the Dataverse.
While you can access the Dataverse via the TDS endpoint, SQL Server and the Dataverse are still very different beasts.
As to the error itself, there's no way we can help you with this one other than to say that it's probably quite correct.
Perhaps run a simple "SELECT TOP 1 * FROM [yourDataverseTableName]" and verify that you haven't made a spelling error with that column name.
Otherwise, you'd have to leverage another approach such as using the Dataverse REST calls or the Power Platform's native environment explorer to try and confirm where the discrepancy lies.
Cheers,
Lain