#dynamicscrm365

Posts tagged with this topic.

Dataverse: Retrieve unmasked data (Masking Rule Column) via KingswaySoft

Mar 21, 2026

New day, new experience to discover! This time, I have a requirement to create an SSIS batch job function. During data retrieval, I found that the column is masked using the Masking Rule. This blog post is a brief note on how to retrieve the unmasked data. Enjoy! Dataverse Column...

Dataverse: How to set a Complex Query for System View

Feb 21, 2026

Sometimes, we need to let the user see only the records under their care (dynamically connected via relationships). For example, we have the Region table > User and Order will be linked to the Region. Hence, the user will only see all the Order records that belong to the same...

Benchmark: TDS Endpoint vs QueryExpression vs FetchExpression

Nov 29, 2025

I read Mark Carrington's blog post about his latest findings on TDS Endpoint revisited, which can be found here. One of the key points that is interesting is his finding about the internal Dataverse message ExecutePowerBISql, which intersects with the function I created last time...

Enable Navigation for Customer Insights - Journeys form

Nov 15, 2025

In Dynamics CRM products, I'm not sure why the Microsoft Product Team isn't enforcing the same UI languages across platforms. For example, in the Customer Insights - Journeys form, they decided to hide the Command and Navigation Bar. Because of this "initiative", it causes some...

How to prevent uploading a malicious file to Dataverse

Nov 1, 2025

Today, we will learn how to make a simple (a low-code approach) way to do prevention of uploading malicious files into Dataverse using SharePoint! Did you know that, by default, all the files that we upload to SharePoint will be scanned automatically using Microsoft Defender for...

Modernizing Audit Summary History using Generative Pages (Preview)!

Oct 25, 2025

In Customer Insight, if you enable audit capability for the Journey table, the only way to view the audit history is through a backend operation or by using the "/tools/audit/audit_details.aspx" page. This page was introduced so long ago, and it is tough to navigate, as we need...

Customer Insights: Get Email Delivery and Interaction Details of Journey

Sep 13, 2025

I got asked by a customer how to get the interaction details of the Journey. By default, in the Journey that is on the status of Going Live or Completed, we can click on the Delivery funnel button to see the drill-down of the information: Delivery funnel information Then, it will...

Dataverse: Address 101

Aug 23, 2025

The bigger your Contacts/Accounts (Customers) data, the more it also consumes your Dataverse Database Capacity. I had a client who had a database overage problem, and further checking, the CustomerAddress table was on the list. If you open the table, you will find lots of empty...