powerplatform

Posts in this category.

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

Azure Function to scrape Yahoo data and store it in SharePoint

Feb 14, 2026

A couple of weeks ago, I learned about an AI Agent from this Microsoft DevBlogs, which mainly talks about building an AI Agent on top of Copilot Studio. So, as a good student, I tried to build my own Agent to learn about Indonesian Stocks. But, for this part, I just want to show...

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

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