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

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

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

Boosting Productivity in Dynamics 365 CRM with JavaScript Bookmarklets

When working with Dynamics 365 CRM, having quick access to relevant data and streamlined workflows is crucial for enhancing productivity. One powerful tool that can assist in achieving this is JavaScript bookmarklets. In this article, we’ll explore how JavaScript bookmarklets can be leveraged to improve productivity in Dynamics 365 CRM by showcasing a few practial … Read more

Removing Rows with Missing Data in Power BI using a Measure

Power BI is a powerful tool for data analysis and visualization. When working with large datasets, it’s common to encounter missing data, which can affect the accuracy of insights and visualizations. In this blog post, we will explore how to create a Power BI measure to remove rows with missing data from a table, ensuring … Read more

Integrate Power BI in D365: Open Power BI Reports with Record Filtering

In this blog post, we will explore how to integrate Dynamics CRM with Power BI by creating a web resource that opens a Power BI report and applies record filtering based on the current CRM record. Prerequisite for this is a already in PowerBI Service hosted Report. The Script The HTML code is creating a … Read more

Enhance Your Power BI Analysis with a Central Date Table

In the realm of data analysis and reporting, effective time-based analysis is essential for gaining valuable insights. Power BI, a powerful business intelligence tool, offers a range of features to handle time-related data. One of the best practices for optimizing time intelligence in Power BI is utilizing a central date table. In this blog post, … Read more