Archive Technical Blogs

Business Intelligence

April 28, 2026 9 min read

🚀 End-to-End Guide: Building a Fivetran Custom Connector (Keap → BigQuery)

1. Introduction In today’s data-driven world, businesses rely heavily on automated data pipelines. While Fivetr...

Read Article

Power BI

April 22, 2025 2 min read

Drill Through from Power BI Table to Paginated Report

What is Drill Through?  Drill-through is a feature in Power BI that allows users to navigate from one report page to...

Read Article

Microsoft Fabric

April 15, 2025 5 min read

Choosing the Right Data Store in Microsoft Fabric: A Guide to Making Smart Decisions

As Microsoft Fabric keeps molding the unified data landscape, many data professionals are faced with a common dilemma...

Read Article

Power BI

March 28, 2025 3 min read

Using Bookmarks and Selection Pane for Interactive Reports in Power BI

Power BI provides powerful features to enhance user interactivity, and two of the most effective tools for this are B...

Read Article

Microsoft Fabric

March 26, 2025 3 min read

Real-Time Alerts with Data Activator and KQL in Microsoft Fabric

In this blog, we will leverage Microsoft Fabric’s Data Activator and Kusto Query Language (KQL) to monitor IoT sens...

Read Article

Microsoft Fabric

March 21, 2025 3 min read

Ensuring Data Integrity in Microsoft Fabric: Validating Excel Headers in Data Pipeline Before Loading Data into the Destination

In data engineering, maintaining data integrity is crucial. One common challenge is ensuring that an incoming file co...

Read Article

Power BI

March 18, 2025 2 min read

Star Schema vs. Snowflake Schema: Choosing the Right Model for Power BI

Building reports in Power BI requires the right data structure for optimal performance. The two main approaches are S...

Read Article

Power BI

March 7, 2025 3 min read

Optimizing Power BI Reports with Performance Analyzer

Struggling with a slow Power BI report? You’re not alone. Slow performance is often caused by complex calculati...

Read Article

Business Central

February 28, 2025 3 min read

How to Utilize the Accounts Receivable Administrator Role Center in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central offers a strong ERP solution adapted to streamline financial operations. One ...

Read Article

Dynamics 365 for Sales

February 21, 2025 3 min read

Lookup CRM Metadata Using API in Postman

In today’s fast-paced digital world, understanding and leveraging metadata is key to building robust, data-driven a...

Read Article

Azure

February 14, 2025 4 min read

Overcoming Lakehouse Limitations: Implementing Upserts with PySpark

Lakehouses combine the best features of data lakes and data warehouses, offering scalable and cost-effective solution...

Read Article

Microsoft Fabric

January 21, 2025 4 min read

Linking Your Dataverse Environment to Microsoft Fabric

Microsoft Fabric offers a robust platform for data integration and analytics. Leveraging the wealth of data stored in...

Read Article

Power Pages

January 17, 2025 2 min read

Stripe Payment Integration with Power Pages

Stripe payment integration is a key feature of Power Pages, allowing users to easily process payments directly within...

Read Article

Power Pages

January 10, 2025 2 min read

Mastering Activity Tracking: Enabling the Activity Timeline in Power Pages for Better Management

Activity timeline is time-tracking and planning control for each record. Activity controls many processes like Appoin...

Read Article

Azure

December 27, 2024 4 min read

How to Build a Pipeline for Exact Matching in Azure ML Using Python Script

Exact matching is a critical process for identifying precise matches between text data and predefined keywords. In th...

Read Article

Dynamics 365 for Sales

December 17, 2024 3 min read

Automating PDF Generation with Dynamics 365 CRM Data Using JSON Mapping and Encodian in Power Automate

In this blog, I will showcase how to seamlessly integrate Dynamics 365 CRM with Encodian to automate the creation o...

Read Article

Power Automate

December 13, 2024 2 min read

Unlocking Efficiency: A Beginner’s Guide to RPA Desktop Flows in Power Automate

As per the beginner’s knowledge, RPA (Robotic Process Automation) Desktop flows, also known as UI flows, are a ...

Read Article

Dynamics 365 for Sales

December 10, 2024 3 min read

How to Populate Prefix in AutoNumber fields based on conditions in Dynamics 365 Sales

Maintaining organized and meaningful data is crucial for effective management and analysis. AutoNumber fields are a p...

Read Article

Dynamics 365 for Sales

December 6, 2024 4 min read

How to use Low-No Code Plugin using Data verse accelerator in dynamics 365

As everybody knows, in Dataverse, if we need to do anything that is not available in OOTB functionality and crucial t...

Read Article

Microsoft Flow

December 3, 2024 4 min read

How to run OOTB Report and send emails with pdf attachments using Power Automate.

These days a speedy-paced business environment and efficient reporting equipment are crucial. Dynamics 365 is a power...

Read Article

ADF

November 29, 2024 8 min read

Split the Text files using ADF Pipelines

Requirements: If the file size of an Excel file exceeds the specified criteria, we need to address the following: The...

Read Article

PowerApps

November 19, 2024 5 min read

Paper to Power App: Creating a Canvas App in D365 CRM from a Hand-Drawn Sketch

Power Apps, known for its low-code/no-code capabilities, now offers the ability to create complete apps from an image...

Read Article

Power Pages

October 1, 2024 2 min read

How to render lookup as dropdown in Powerpage

In today’s digital landscape, creating user-friendly interfaces is essential, especially when building applications...

Read Article

Microsoft Flow

September 27, 2024 4 min read

Use Power Automate to get Name and Email Address in Outlook Online

Read Article

Microsoft Flow

September 24, 2024 2 min read

Invoker’s Connection in Power Automate

We’ve been using Power Automate extensively to automate operations in Dynamics 365 using the Dataverse connectors. ...

Read Article

Power BI

September 10, 2024 5 min read

Introduction to Data Science in Microsoft Fabric

As an end-to-end SaaS Microsoft Fabric multiple workloads or components including Data Science. In this blog we will ...

Read Article

Business Central

September 6, 2024 3 min read

Managing Posting Restrictions on Sales/Purchase Document According to various users in MS Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide ...

Read Article

Business Central

August 30, 2024 7 min read

How to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide ...

Read Article

Business Central

August 21, 2024 3 min read

Cancel Multiple Posted Sales Invoices using Job Queue in MS Dynamics 365 Business Central using AL Code

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide ...

Read Article

ADF

August 16, 2024 3 min read

Copying Excel files from source to destination in Excel format using ADF Pipeline

As Azure Data Factory (ADF) does not offer Excel as a sink option, an alternative method is required to copy Excel fi...

Read Article

Business Central

August 13, 2024 7 min read

Creating a Custom Job Queue to create Sales order from Purchase order in MS Dynamics 365 Business Central using AL Code

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide ...

Read Article

ADF

August 2, 2024 2 min read

Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF

The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data...

Read Article

Business Central

July 30, 2024 4 min read

How to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide ...

Read Article

Business Central

July 16, 2024 3 min read

Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide ...

Read Article

Power BI

July 3, 2024 3 min read

Microsoft Power BI consulting: Introduction to the new Button Slicer

The Power BI has introduced a new button slicer which resembles somewhat to the custom slicer, i.e., the Chiclet slic...

Read Article

Business Central

June 27, 2024 5 min read

Dynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of c...

Read Article

Power BI

June 19, 2024 3 min read

Microsoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).

In this blog, we are going to explore the new feature to use the Calculation Groups using Power BI Desktop and Micros...

Read Article

Business Central

June 10, 2024 5 min read

Dynamics 365 Business Central

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of c...

Read Article

Microsoft Flow

June 4, 2024 4 min read

Power Automate: Track Multiple Microsoft Survey Forms Responses

In the realm of Microsoft Forms and Power Automate integration, “When a new response is submitted” connec...

Read Article

Business Central

May 17, 2024 4 min read

How to use SecretText Data type in Business Central

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of c...

Read Article