Recent Posts


Audit Entity / Table – Few key points (Dynamics 365 / Power Apps)

In the earlier post we looked at different ways of extracting Audit History data. Extract Audit History –https://nishantrana.me/2021/05/17/how-to-export-the-audit-history-values-from-dynamics-365/ We can use Microsoft 365 Security and Compliance Center for the same, though it is limited to the Production environment only. https://docs.microsoft.com/en-us/power-platform/admin/enable-use-comprehensive-auditing#requirementsContinue reading “Audit Entity / Table – Few key points (Dynamics 365 / Power Apps)”

https://acloudguru.com/blog/engineering/a-visual-guide-to-azure-data-factory

How to – Export Dataverse (Dynamics 365) data to Azure SQL using Azure Data Factory pipeline template

[Visual Guide to Azure Data Factory – https://acloudguru.com/blog/engineering/a-visual-guide-to-azure-data-factory%5D Using the new Azure Data Factory pipeline template – Copy Dataverse data from Azure Data Lake to Azure SQL – we can now easily export the Dataverse data to Azure SQL Database. … Continue reading “How to – Export Dataverse (Dynamics 365) data to Azure SQL using Azure Data Factory pipeline template”

Wave 2 Gives a New Look to Views

Originally posted on KKIT365:
Remember the time you needed to add a column to a view but were worried about spoiling the layering of the solutions so ended up using the Advance find to edit columns and create a personal…

Solved– No function signature for the function with name ‘contains’ matches the specified arguments in Canvas Apps

We were getting the below error while trying to set the Items property of the Gallery control and were using Filters in the formula. “The requested operation is invalid. Server Response: Sectors failed: No function signature for the function with … Continue reading “Solved– No function signature for the function with name ‘contains’ matches the specified arguments in Canvas Apps”

Update Personal Options / Personalization Settings using UpdateUserSettingsSystemUser Request – Dynamics 365

Recently we had a requirement to update the “Negative Currency Format” – Regional Options for all the users. We could not find this option in our favorite plugin – User Settings Utility. So to programmatically update it we use the … Continue reading “Update Personal Options / Personalization Settings using UpdateUserSettingsSystemUser Request – Dynamics 365”

Interactive login option in CDS/CRM Connection Manager in KingswaySoft Dynamics 365 Integration Toolkit

With the new release, the CDS/CRM connection manager adds a new Interactive Login option in the CDS/CRM Connection Manager for Authentication Type as OAuth. Interactive login allows the user to log in using his account details (to establish the connection … Continue reading “Interactive login option in CDS/CRM Connection Manager in KingswaySoft Dynamics 365 Integration Toolkit”

Enable parent check option during Merge – Dynamics 365

The duplicate detection/merge feature has been optimized in the platform https://nishantrana.me/2020/10/29/improved-duplicate-detection-and-merge-experience-in-dynamics-365-for-sales-2020-release-wave-2/ and now uses the new interface replacing the legacy web client. The legacy experience – The enhanced experience – now with merge option. Merge allows to select up to … Continue reading “Enable parent check option during Merge – Dynamics 365”

Fixed – AuthorizationFailed. The client with object id does not have authorization to perform action ‘’Microsoft.Authorization/roleAssignments/write’ over scope ‘storageaccount’ – Azure Data Lake

While configuring the Azure Synapse Link/ Export to Data Lake service, we were getting below error for one of the users. {“code”:”AuthorizationFailed”,”message”:”The client ‘nishantr@pmaurua105.onmicrosoft.com’ with object id ‘d56d5fbb-0d46-4814-afaa-e429e5f252c8’ does not have authorization to perform action ‘Microsoft.Authorization/roleAssignments/write’ over scope ‘/subscriptions/30ed4d5c-4377-4df1-a341-8f801a7943ad/resourceGroups/RG/providers/Microsoft.Storage/storageAccounts/saazuredatalakecrm/providers/Microsoft.Authorization/roleAssignments/2eb81813-3b38-4b2e-bc14-f649263b5fcf’ or … Continue reading “Fixed – AuthorizationFailed. The client with object id does not have authorization to perform action ‘’Microsoft.Authorization/roleAssignments/write’ over scope ‘storageaccount’ – Azure Data Lake”

Create Power BI Report to analyze Dataverse / Dynamics 365 data in Azure Data Lake

To begin with, here we have already configured the Azure Synapse Link /Export to Data Lake service and have configured Account, Contact and User table for the sync. Check posts on Azure Synapse Link/  Export to Data Lake service: https://nishantrana.me/2020/12/10/posts-on-azure-data-lake/Continue reading “Create Power BI Report to analyze Dataverse / Dynamics 365 data in Azure Data Lake”

Secrets of the Dataverse: The Report Wizard

Originally posted on ReadyXRM:
Anyone who has been working with Dynamics CRM/Dynamics 365 at some point likely tried the Report Wizard. The Report Wizard was introduced in Dynamics CRM v4.0 as a way to quickly create ad-hoc reports. A video…

How to – improve data migration performance – SSIS & Azure Data Factory (Dataverse / Dynamics 365)

In one of our projects, we were executing SSIS Packages (KingswaySoft’s Dynamics 365 SSIS Integration Toolkit) under Azure-SSIS Integration Runtime in Azure Data Factory. Check out – Deploy and run SSIS Package in Azure Data Factory Deploy and run SSIS … Continue reading “How to – improve data migration performance – SSIS & Azure Data Factory (Dataverse / Dynamics 365)”

Loading…

Something went wrong. Please refresh the page and/or try again.

Advertisements

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

2 thoughts on “Recent Posts”

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.