#dynamicscrm

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...

Dataverse: Get best Threads and Rows Count

Feb 1, 2026

To know the best settings for pushing data to Dataverse is tedious work (for batch processing). We need to consider the client hardware (Logical processor - to support multithreading and ram capacity), Network, and also it is unique for each of the tables that you want to run...

What I learned about SSIS

Jan 16, 2026

Happy New Year, everyone! Today, I want to share a list of knowledge that I have gained since I started learning SSIS - KingswaySoft! Certainly, the tips I wrote here may not be applicable/outdated later on, and you can call them out or discuss with me if you think I have a wrong...

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...