What Is TDS And How To Enable TDS In Dynamics 365 CE Online

TDS stands for Tabular Data Stream (TDS). TDS is a Protocol and it is an endpoint for the Dataverse.

This endpoint enables us to connect to the Dataverse for accessing the data in Dynamics 365 CE or Power Platform environments. This endpoint allows read-only access to the system for reporting and analytics. TDS endpoint is managed by a System Administrator. The best part is that you can see the data based on your security roles provided in Dynamics 365 CE.

Using this TDS, you can connect to SSMS (v18.4 and higher) and Power BI applications.

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure from SQL Server to Azure SQL Database. This Dataverse TDS endpoint allows us to perform read-only T-SQL queries that runs on the server.

Power BI desktop used to create reports on the data sets. Using this Dataverse TDS, from the Power BI desktop, you can connect to Dynamics 365 CE/ Power Platform environments and create Power BI Dashboards/ Reports with the native security.

Now, will see how to enable TDS endpoint for the Dynamics CE environment.

Follow the below steps for the same.

Step 1

Login to Power Platform Admin Center (PPAC) with valid credentials.

Step 2

Click on the required Environment name.

Step 3

Click on Settings.

Step 4

Expand Product and Click on Features.

Step 5

Click on Enable TDS endpoint and make sure it is On.

Step 6

Click on Save to save this setting.

Hope you have successfully enabled TDS endpoint in Power Platform admin center for your required environment.

Please like and share your valuable feedback on this article.