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

3 Methods To Configure Your Power BI Dataset Refresh Schedule

In Microsofts data driven universe, keeping your Power BI reports up-to-date is crucial. Power BI offers several ways to configure refresh schedules, ensuring your data is always current. In this blog post, we’ll explore three effective methods to schedule dataset refreshes and keep your Power BI reports running smoothly with up to date data. Method … 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

Accessing Optionset Display values and their corresponding numeric values with the hidden Stringmaps entity

One of the lesser-known but incredibly powerful tables in Dataverse is the “Stringmaps” table. This table holds a treasure trove of information about optionsets and their options, making it a valuable resource for developers and administrators alike. In this blog post, we’ll dive deep into the “Stringmaps” table, understanding its structure and how it helps … 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

Connection to CRM Organization with Python

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

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