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)

Paginated reports in Power BI: Successor to SSRS Reports

With the rising popularity of Power BI, we can design fancy dashboards and reports. But, what if we need to design and download reports similar to traditional SSRS reports?Well, Power BI service supports similar reports which can be build using Power BI Paginated Report Builder. Although there are few limitations but if you are considering Power BI for reporting purpose then maybe you want to check this feature. What are…

Continue ReadingPaginated reports in Power BI: Successor to SSRS Reports