I’m pleased to announce SQL 4 CDS 4.0.1 for working with your Dataverse data in SQL. This includes a number of improvements to SQL language support, error reporting and SSMS support.
PCF Usage Inspector 1.2.1 Released
I’m pleased to announce the release of PCF Usage Inspector v1.2.1 for XrmToolBox today. This release adds some key new functionality to let you make sure you’re using PCF controls consistently across your environments. If you’ve just developed or imported a great new PCF control, PCF Usage Inspector can help Continue Reading
Using Dates from TDS Endpoint in Power BI Charts
As part of migrating some dashboards to Power BI using the TDS Endpoint I hit a problem getting a chart to show correctly. I needed to show invoices with the values grouped by month. This is simple in a standard Dynamics chart, and when importing the data into Power BI. Continue Reading
SQL 4 CDS 4.0.0 Released
I’m pleased to announce the release of version 4.0.0 of SQL 4 CDS. This release introduces SQL 4 CDS – SSMS Edition, bringing many of the SQL 4 CDS features directly into SQL Server Management Studio! If you’re using the TDS endpoint this plugin expands your options directly in SSMS Continue Reading
TDS Endpoint Queries with Time Zone and User details
A common issue I used to encounter with SQL-based reports for on-premise Dynamics CRM instances was correctly & efficiently filtering on dates. In the underlying SQL tables, Dataverse stores dates & times in UTC time zone, and this is how they’re indexed. In the views that the TDS Endpoint exposes Continue Reading