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
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
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
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
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
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
Connecting to a CRM organization and securely accessing its data can sometimes be a complex task. In this blog post, we will explore a Python script that leverages Microsoft Azure Active Directory and OAuth 2.0 authentication to streamline the process of connecting to a CRM organization. By the end, you’ll have a clear understanding of … Read more
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
Handling large CSV files efficiently is a common challenge for data analysts and IT professionals alike. Manipulating such files can be time-consuming and resource-intensive, often resulting in performance issues. In this blog post, we will explore a PowerShell script that helps break down large CSV files into smaller, more manageable chunks. By leveraging PowerShell’s capabilities, … Read more
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