Posts

Remote Desktop Error : Remote Desktop Displays Strange Pattern in White Areas

Image
 Hi there, today we are going to look into a common remote desktop issue. It happens when a user connects via remote desktop, and it displays a strange pattern of black boxes showing all over the white spaces. Even after trying to restart, the issue remains the same. To avoid this, you need to clear the remote desktop cache. Ensure that you close all remote desktop sessions before proceeding.  Then navigate to the cache folder. The cache files are usually stored in the C:\Users\[YourUsername]\AppData\Local\Microsoft\Terminal Server Client\Cache folder .  Delete all the files within the Cache folder. These files typically have .bmc, .bmc2, and other similar extensions.

Power Automate Error: Handling Empty Cells When Uploading Excel Data to SharePoint Lists

Image
Error :  The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/SST' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'. When users attempt to upload Excel file data using Power Automate, this issue commonly happens. The reason is that the Excel table contains empty cells. Proper configuration in Power Automate is necessary to avoid this problem. It's a simple fix, and I'll show you how to implement it. Before the fix, it looks like this: items('Apply_to_each')['XXX']) Just need to add a condition as below: if(empty(items('Apply_to_each')['XXX']),null,items('Apply_to_each')['XXX']) This formula describes the following: If the value of the 'XXX' field for the current item is empty, it will retu...

Step-by-Step Guide: Creating an Azure Synapse Link for Dataverse

Image
Hello everyone, in this article, we are going to discuss how to connect your Dataverse tables to Azure Synapse workspace. First, we are going to look at what is the Dataverse and What is the Azure Synapse link for Dataverse. What is Dataverse Dataverse is a cloud-based storage space formerly known as the Common Data Service (CDS). It allows users to securely store data within sets of tables. We can use Dataverse as a data source for business applications such as the Power Platform and Dynamics 365. What is Azure Synapse Link for Dataverse? Azure Synapse Link for Dataverse allows you to easily analyze your Dataverse data using Azure Synapse Analytics without needing to move the data around or use complex processes. It makes data analysis simpler and faster.  Once the link is established, Azure Synapse Link for Dataverse will export all the initial data and continuously sync any new changes. This allows customers to gain near real-time insights from their data stored in Microsoft Dat...