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

Securing Dynamics 365: Disabling Subgrid Access Based on Security Roles

Dynamics 365 provides a robust platform for managing customer relationships and streamlining business processes. One critical aspect of maintaining data integrity is ensuring that only authorized users can perform certain actions within the system. In this blog post, we will explore a JavaScript approach to disable a subgrid on the marketing list entity in Dynamics … Read more

Transforming Your Netflix View Data into Powerful Power BI Reports

In today’s data-driven world, extracting meaningful insights from various sources is key to making informed decisions. If you’re a Netflix enthusiast looking to analyze your viewing patterns and gain valuable insights, this tutorial will guide you through the process of converting your Netflix view data into visually appealing Power BI reports. By leveraging the power … Read more

How to receive free Microsoft certifiction vouchers

In today’s fast-paced tech industry, continuous learning is paramount to staying ahead of the curve. Microsoft, a renowned technology leader, recognizes the significance of upskilling and offers an excellent opportunity through its Virtual Training Days program. These free training courses, tailored for individuals already familiar with Microsoft, provide a pathway to earn vouchers for certifications … Read more

Removing numbers from User Input in Microsoft Dynamics 365 Fields using JavaScript

Microsoft Dynamics 365 is a powerful customer relationship management (CRM) platform that provides organizations with a wide range of features to manage and analyze customer interactions. One common requirement in CRM systems is to sanitize user input by removing specific characters or data types. Having good data quality can be key in avoiding duplicates and … Read more

Dealing with expiration of PowerBI (Service) Credentials

In today’s data-driven world, organizations heavily rely on business intelligence tools to gain valuable insights and make informed decisions. Microsoft Power BI has emerged as a popular choice, offering powerful features and functionality. However, like any software platform, it is not without its challenges. One such issue that Power BI users encounter is the expiration … Read more

Cancel a variety of Microsoft Power Automate flows

Today I was faced with the task of maintaining a quite complex flow with several wait conditions. Some of these conditions should be changed, the running flows should be canceled, the flow should be processed and restarted. But at the current time there were already flows waiting. Many flows. Actually, a total of 170 of … Read more