PowerBi and Frequently Updated Datasources – fixing The data source appears to have been modified since it was last accessed

Are you grappling with the frustrating issue of intermittent data refresh failures in Power BI when accessing your Azure Synapse Link Data within Azure Data Lake? You’re not alone. Many Power BI users have encountered the error message: AzureBlobs: The data source appears to have been modified since it was last accessed. Refreshing may resolve … Read more

Azure Data Factory: Fix NULL Values In Date Colums

Introduction If you are Azure Data Factory (ADF) to work with Azure Synapse Link and Dataverse Data, (I’ve blogged about it here) ensuring data accuracy and consistency can be challenging. In this blog post, we will address a common issue faced by many users: NULL values in date columns. I’ll guide you through the process … Read more

Azure Machine Learning: Fixing Authentication Error AADSTS70020 / AADSTS70016

Migrating your Azure Machine Learning Workspace to a new subscription can be a daunting task. You’ve recreated your setup, scheduled your pipelines, finished your python scripts and are eager to start using it. But wait, an unexpected Authentication Error AADSTS70020 or AADSTS70016 is halting your progress! In this blog post, we’ll dive into the solution … Read more

Resolving Microsoft Azure Synapse Analytics Workspace Access Issues (Error Code 403)

Are you encountering a frustrating “Failed to load one or more resources due to no access error code 403” message while trying to access your Microsoft Azure Synapse Analytics Workspace? Don’t worry; you’re not alone, and there’s a solution! Understanding the Issue This error may occur even if your user account has Owner permissions for … Read more

Fixing the ‘503 Server is Busy’ Error

Power BI is a powerful business intelligence tool that allows organizations to create interactive reports and dashboards. To ensure that your data is up-to-date, Power BI allows you to schedule data refreshes using Powerbi-Dataflows. However, when working with data sources like Azure Data Lake Gen2, you may encounter issues like the “Server is Busy” error. … Read more

Automating Azure Machine Learning Studio Pipelines

Gathering and preparing data for training can be a time-consuming process. In the world of machine learning, data is the foundation upon which successful models are built. Azure offers a powerful solution by combining Azure Data Factory and Azure Machine Learning Studio to automate the creation of datasets and the subsequent training pipeline. In this … Read more

Simplifying Data Backups: Backing up Dynamics CRM to Azure Data Lake using Azure Synapse Link

Dynamics CRM, a powerful CRM platform offered by Microsoft, plays a pivotal role in managing customer interactions, sales, and other crucial business processes. However, ensuring the security and availability of this vital data is of paramount importance. That’s where data backups come into the picture. This blog post explores the significance of safeguarding crucial data … Read more

Identifying Unused Azure Resources in Your Subscription with PowerShell

In any Azure subscription, over time, you may accumulate a variety of resources that are no longer actively being used. These unused resources can contribute to unnecessary costs and clutter in your environment. To optimize your Azure infrastructure, it’s essential to identify and manage these resources efficiently. In this blog post, we’ll explore how you … Read more

Restart Azure VM with PowerShell and Service Principle

Make sure to replace the placeholders (YOUR_TENANT_ID, YOUR_CLIENT_ID, YOUR_CLIENT_SECRET, YOUR_SUBSCRIPTION_ID, YOUR_RESOURCE_GROUP_NAME,YOUR_VM_’NAME) with your actual values. This script first authenticates with Azure using the provided service principal credentials ($tenantId, $clientId, $clientSecret). Then it connects to the Azure account using the service principal credentials. After successful authentication, the script restarts the specified virtual machine ($vmName) in the … Read more