Getting error when dataverse connecting through MS SQL SERVER 2022

Copper Contributor

HI, I am getting error message


TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


"Invalid column name 'is_dropped_ledger_column'."
RequestId: TDS;1e3443e5-c370-40a1-98a6-043ec6d6cdd7;10
Time: 2023-04-07T05:51:35.1090605Z (Microsoft SQL Server, Error: 40000)

For help, click:


If you anyone have answer. Please help me.





1 Reply



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.