Its been a while since Microsoft unveiled TDS or Tabular Data Stream endpoint in Dynamics 365 CE or dataverse. As the name sounds its a endpoint and it can be used to retrieve data.
Previous back in 2019 when I was developing few Power BI reports out of D365 CE Sales I found a major challenge to implement the D365 CE’s security model inside Power BI reports. Power BI has RLS(Row Level Security) but using RLS it was very hard to mimic D365 CE security model where the access controls were not only limited to owning team or user but also access teams, sharing and hierarchical security model. I remember to support RLS we had to make a lot of data structure related changes inside D365 CE.
But gone are those days! if you read the Microsoft’s documentation on TDS it says TDS endpoint has the capability to restrict user as per their security role in D365 CE itself. Data can be retrieved in read-only mode and as per dataverse security model. TDS endpoint can be used in Power BI & as well SSIS for reporting purpose. In this article , I have explained how to enable/disable TDS endpoint in your dataverse environment.
Please feel free to share your feedback through comment section. In case you are new to D365 CE or dataverse you can register for a 30 days free trial to start with.
Hi there! I am Anirban Mukherjee. I have a total experience of more than 8 years in the area of Microsoft Dynamics 365 configuration and customization, Power Apps and Power BI. Apart from that I also have decent knowledge in SSIS and SSRS. In case you need to contact me , please visit my LinkedIn profile or use the contact us page.
1 thought on “What is Tabular Data Stream (TDS) endpoint ?”