Post
Ask Question

What is TDS Endpoint and How to Enable TDS in Dynamics 365 Customer Engagement/CRM Online?

Introduction

TDS (Tabular Data Stream) is a powerful protocol that allows seamless connectivity to the Dataverse in Dynamics 365 CE and Power Platform environments. In this article, we’ll explore what TDS is, its benefits, and how to enable it for your Dynamics 365 CE environment.

What Is TDS?

TDS serves as an endpoint for the Dataverse, enabling read-only access to system data for reporting and analytics. As a Dataverse administrator, you can leverage TDS to connect to SQL Server Management Studio (SSMS) and Power BI applications. Let’s dive into the details.

TDS

Benefits of TDS

  1. Native Security Integration: TDS allows you to access data based on your security roles in Dynamics 365 CE. This means you can query the system without compromising security.
  2. SSMS Integration: With TDS, you can connect to SSMS (v18.4 and higher) and execute read-only T-SQL queries directly on the server.
  3. Power BI Reports: Create Power BI dashboards and reports using TDS. Power BI Desktop seamlessly connects to Dynamics 365 CE/Power Platform environments, ensuring native security is maintained.

How to Enable TDS in Dynamics 365 CE Online

Follow these steps to enable TDS for your environment.

Log in to the Power Platform Admin Center (PPAC)

  • Use valid credentials to access PPAC.
  • Click on the required environment name.
    PPAC

Navigate to Settings

Click on “Settings” in the left navigation pane.

Settings

Expand the Product and Click on Features

  • Find the “Features” section.
    Features
  • Click on “Enable TDS endpoint” and ensure it’s turned on.
    TDS Endpoint

Save your Settings

Click “Save” to apply the changes.

Conclusion

TDS is a game-changer for accessing Dataverse data securely. By enabling the TDS endpoint, you unlock powerful capabilities for reporting, analytics, and Power BI integration. So go ahead, activate TDS, and explore the possibilities!

FAQs
 

Q. Can I use TDS for custom views?

A. No, TDS provides read-only access to table data. Custom views are not supported.

Q. What authentication methods are supported?

A. Only Microsoft Entra ID authentication is supported; SQL authentication and Windows authentication are not.


Similar Articles