If you need to make bulk updates to your Dataverse or Dynamics 365 data, maybe to fix data quality problems or restructure your data, you may be exporting your data to Excel, making your changes and re-importing it. Or you may be considering setting up a more complex data pipeline Continue Reading
SQL 4 CDS 4.0.1 Released
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
Automating XrmToolBox Tool Build & Release
Following up on this call to action from Jonas Rapp: 📢 Calling all @XrmToolBox tool developers! Are you still building and releasing your tools manually? Stop that.Now.https://t.co/47pjRKAOT1 — Jonas Rapp ᴹᴠᴾ 🇸🇪 #ProCodeNoCodeUnite (@rappen) December 2, 2020 I decided to finally automate the build & release process for SQL 4 Continue Reading
SQL 4 CDS 3.1.0 released
I’m pleased to announce that SQL 4 CDS 3.1.0 is now available to download in XrmToolBox! This release includes a lot of performance and usability related changes.
Dataverse Paging with Distinct
I hit a strange situation yesterday. I was retrieving data from Dataverse with a FetchXML query but some values were missing from my results, while others were duplicated. Turns out it’s an easy situation to get into without noticing.
Improving Insert/Update/Delete Performance in D365/Dataverse
One of the most popular features of SQL 4 CDS has proven to be the ability to change data using INSERT, UPDATE and DELETE statements. To that end, I’ve been looking at how to improve the performance of these types of queries. Whilst I’ve been doing this with a view Continue Reading