Query CDS Data using SQL from Power BI or SSMS (Preview)

Recently Microsoft has announced a preview of an additional way to access read-only data in CDS. The TDS endpoint for CDS allows read-only access to the system for reporting and analytics. The Tabular Data Stream (TDS) Protocol endpoint is managed by an administrator. So far,  the CDS OData endpoint served as the single access point for all types of operations. In this preview feature, the TDS endpoint is limited to read-only actions. As TDS implies, Power…

Continue ReadingQuery CDS Data using SQL from Power BI or SSMS (Preview)