Query Dataverse Tables with SQL Server Management Studio
Updated: Dec 7, 2022
You can query your Dataverse tables with SQL Server Management Studio - this is a great tool for anyone out there implementing Business Application Projects.
II Benefit: This is a free feature and a great time saver!
1.Download SQL Server Management Studio Express
2.Connect to your Dataverse Environment
-ServerType : Database Engine
-ServerName: the organization address URL (Your Dataverse URL)
-Only Azure Active Directory authentication is supported. SQL authentication and Windows authentication aren't supported.
This is officially on Microsoft Learn right now!