Archive

Data Engineering

June 23, 2026 5 min read

Fabric Notebook: Mastering Lakehouse and Warehouse Data Movement (Same & Cross Workspace)

In Microsoft Fabric, one of the most powerful capabilities is seamless data movement between Lakehouses and Warehouse...

Read Article

Data Engineering

June 19, 2026 4 min read

Designing Scalable KPI Matrices in Power BI: Dynamic Row-Level Logic with Clean Architecture

A Scalable Approach for Handling Multiple KPIs with Independent Logic Introduction In Power BI, measures are designed...

Read Article

Data Engineering

June 16, 2026 5 min read

Securing Databricks Notebooks: Moving Beyond Hard-Coded Passwords with Secret Scopes

Modern data workflows frequently interact with external systems of databases, APIs, cloud storage, and third-party se...

Read Article

Business Central

June 12, 2026 3 min read

How to Avoid Document Number Errors When Posting Project Journals in Microsoft Dynamics 365 Business Central?

Introduction Posting project journals in Microsoft Dynamics 365 Business Central requires correct document numbering ...

Read Article

Business Central

June 9, 2026 3 min read

Use Edit in Excel on Output, Consumption, and Item Journals in Microsoft Dynamics 365 Business Central

Introduction: Microsoft Dynamics 365 Business Central continues to enhance its usability by expanding the Edit in Exc...

Read Article

Power BI

June 5, 2026 4 min read

Designing Scalable KPI Matrices in Power BI: Dynamic Row-Level Logic with Clean Architecture

A Scalable Approach for Handling Multiple KPIs with Independent Logic Introduction In Power BI, measures are designed...

Read Article

Power BI

June 2, 2026 10 min read

Write Once, Reuse Everywhere: DAX UDFs in Power BI

Power BI’s DAX (Data Analysis Expressions) language has long been a cornerstone for creating dynamic calculations i...

Read Article

Business Central

May 29, 2026 3 min read

Automatically Create Contacts for Customers, Vendors, and Bank Accounts in Business Central

Introduction Microsoft Dynamics 365 Business Central tightly integrates master data with its marketing and relationsh...

Read Article

Business Central

May 26, 2026 3 min read

How to Define Item Attributes for Item Variants in Microsoft Dynamics 365 Business Central?

Introduction In the latest updates of Microsoft Dynamics 365 Business Central (Release Wave 2026), Microsoft introduc...

Read Article

Power BI

May 22, 2026 3 min read

Never Use an Outdated Report Again: Version Tracking in Power BI

Introduction In Power BI development, maintaining version control of reports is essential to ensure that all changes ...

Read Article

Power Automate

May 19, 2026 3 min read

From Prompt to Flow: Generating Power Automate Workflows Using AI

Problem Statement Creating flows in Microsoft Power Automate using the traditional approach can take a lot of time. D...

Read Article

Microsoft Dynamics 365

May 15, 2026 4 min read

Generating PDF/Excel, or SSRS Reports for Selected Records Using Power Automate in Dynamics 365

When you’re working with reports in Microsoft Dynamics 365, one common challenge is generating SSRS reports for...

Read Article

PowerApps

May 12, 2026 5 min read

Creating an automated Language Translator in Power Apps Using AI Builder

In multilingual business environments, data consistency is one of the most underestimated challenges. When users work...

Read Article

Business Central

May 8, 2026 4 min read

How to Combine Service Shipments into a Single Invoice in Microsoft Dynamics 365 Business Central

Introduction: Microsoft Dynamics 365 Business Central is constantly improving as an all-in-one business management so...

Read Article

Power BI

May 5, 2026 3 min read

Power BI Web API Integration with Bearer Token & Refresh Configuration

Introduction Power BI provides robust capabilities to integrate external data sources, including REST APIs, through P...

Read Article

Business Central

May 1, 2026 4 min read

Hiding Sales Order Agent and Payables Agent Icons in Microsoft Dynamics 365 Business Central

Introduction: Microsoft Dynamics 365 Business Central continues to evolve by introducing new AI-driven capabilities t...

Read Article

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

Business Central

April 24, 2026 3 min read

How to Efficiently Use Deferral Codes in Sales and Purchase Journals in MS Dynamics 365 Business Central

Introduction Entering sales and purchase journals often involves transactions that require deferrals. In New Released...

Read Article

Business Central

April 21, 2026 2 min read

How to Use standard terminology for project management in Microsoft Dynamics 365 Business Central

Introduction: We’re excited to share an important update aimed at improving your experience with project accounting...

Read Article

Business Central

April 17, 2026 3 min read

How to Manage Document Attachments from Customer to Service Order in Service Management in Microsoft Dynamics 365 Business Central? 

Introduction Managing important documents is crucial for service operations. Microsoft Dynamics 365 Business Central ...

Read Article

Power BI

April 14, 2026 2 min read

Power BI Matrix: Remove Bold Row Headers & Achieve Table-Like Formatting Without Losing Drill-Down

Problem Statement In Power BI’s Matrix visual, adding multiple fields to the Rows section causes parent row hea...

Read Article

Business Central

April 10, 2026 2 min read

How to Resize Columns in Microsoft Dynamics 365 Business Central Without Personalization?

Introduction Microsoft Dynamics 365 Business Central continues to improve user experience by offering greater flexibi...

Read Article

Power BI

April 7, 2026 4 min read

Dynamic Rating Sentences in Power BI

Introduction In many Power BI reports, especially those capturing user feedback or survey responses, you may want to ...

Read Article

PowerApps

April 3, 2026 2 min read

Generating QR Code via a direct API call

Problem Statement Power Apps does not have a built-in feature to generate QR codes. Because of this, creating QR code...

Read Article

Power Pages

March 31, 2026 2 min read

How to Use Print Function in Canvas App

Problem Statement: Developers working with Power Apps in Dynamics 365 CRM often need to generate printable outputs su...

Read Article

Business Central

March 27, 2026 4 min read

How to Use Modern Search in Lists in Microsoft Dynamics 365 Business Central

Introduction: Microsoft Dynamics 365 Business Central continues to enhance user productivity with each release. With ...

Read Article

Microsoft Fabric

March 17, 2026 4 min read

Why Microsoft Fabric Dataflow Loads Partial Data When Triggered from Pipeline (But Works on Rerun)

Introduction If you are working with Microsoft Fabric Dataflow Gen2 triggered through a Pipeline, you might encounter...

Read Article

Power BI

March 13, 2026 4 min read

Turning a Matrix Visual into a Calendar View in Power BI

Introduction In Power BI, there is no out-of-the-box calendar visual available by default. To build calendar-style vi...

Read Article

Power BI

March 10, 2026 4 min read

Alternative way of Navigation for Power BI’s Table Visuals Using Pagination

Introduction In many Power BI reports, table visuals are often designed with scroll bars, even when the amount of dat...

Read Article

Business Central

March 6, 2026 4 min read

How to Block Items or Variants from Service Transactions in Microsoft Dynamics 365 Business Central?

Introduction Managing service transactions efficiently is crucial for maintaining smooth service operations. With the...

Read Article

Microsoft Fabric

March 3, 2026 3 min read

Full load and Incremental load in Microsoft Fabric 

In any data platform, especially in Microsoft Fabric, which provides a unified analytics environment across Data Eng...

Read Article

Power BI

February 24, 2026 5 min read

Design Smarter Power BI Matrices with Conditional Formatting for Row and Column Totals 

Introduction: The Resource Allocation Challenge in IT  Effective resource planning is vital for IT project success, ...

Read Article

Power BI

February 20, 2026 3 min read

Solving Data Access Limitations in Power BI Using Service Principal and Cloud Connection

Overview Power BI’s default behavior—respecting CRM security roles via OAuth—works well when users should s...

Read Article

Microsoft Fabric

February 17, 2026 5 min read

Deployment Pipelines in MS Fabric

Microsoft Fabric’s deployment pipelines tool provides developers with a production environment where they can c...

Read Article

Business Central

February 13, 2026 6 min read

Dynamics GP to Business Central in 2026

Turning End of Life Into a Smart Growth Opportunity This article is intended for finance leaders, IT managers, and Dy...

Read Article

Microsoft Fabric

February 10, 2026 5 min read

The Ultimate Guide to Microsoft Fabric Variable Libraries

Centralize configuration, automate deployments, and master the “Value Set” workflow in Microsoft Fabric. ...

Read Article

Power Pages

February 6, 2026 3 min read

How To Download SharePoint List Attachment Without Power Automate in Canvas App or Custom Page

Downloading Attachments from a SharePoint List Record We have created a SharePoint list where we added two records, e...

Read Article

Power Pages

February 3, 2026 3 min read

Designing a Seamless User Journey with Multistep Forms

Power Pages provides a very important feature called the Multistep Form. This feature allows you to break down comple...

Read Article

Power Pages

January 30, 2026 2 min read

Creating Basic Forms in Power Pages: A Beginner’s Guide

Power Pages offers a Basic Form feature that supports low-code/no-code development, making it easier for users to int...

Read Article

Power Pages

January 27, 2026 3 min read

Designing the Perfect List with Best Practices for Displaying Dataverse Data

Power Pages List is a data display UI component that connects to a Dataverse table in Dynamics 365. It displays data ...

Read Article