Posts tagged with this topic.
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...
If you remember, I created this blog post on how to create a class that wrapped ServiceClient. I must do it because instancing a ServiceClient is expensive (around 2 seconds). Hence, I need to find a way to "store" it in memory and ensure it is always ready when I need to call...
We must construct the SQL Connection String when connecting to Dataverse TDS Endpoints via .NET code. The structure of it by default is just "Server={orgname}.crm.dynamics.com;Database={orgname};Persist Security Info=False;". When we talk about SQL connection strings, there are...
For those who don't know, we already have UpsertRequest for so long (I learned how to use it correctly in this blog post that you can read here). UpsertRequest is a feature where we can request Dataverse to create or update the data based on columns that we are defined. In...
Do you know we can pass the partitionID parameter when doing CRUD to improve performance? The information I got from this documentation link. Today we will prove how what is the difference between using the partitionID and not using it. To collect the data, I'll run below code:...
In my company where I work, we have a custom program that will process big load data. Per running, it can process around 50.000 records. The average finished can be more than 3 hours ++. After I check, one of the things that make this slowness is because of the retrieving...