Our Latest Perspectives

Power BI

April 12, 2024 4 min read

Power BI Consulting: Switching between Aggregated Value and Break downed values using Field Parameters

Switching between aggregated values and breakdown values using Field Parameters in Microsoft Power BI allows users th...

Read Article

Power BI

April 5, 2024 7 min read

Microsoft Power BI Consulting: How to get the data from the outlook attachment and load it to the Power BI report

In the dynamic realm of data analytics and Microsoft Power BI Consulting, incorporating Excel files into Microsoft Po...

Read Article

Power BI

April 2, 2024 8 min read

Introducing Explore this data feature in PowerBI service

In Power BI, users often find the need for spontaneous exploration of their data, particularly when gaining access to...

Read Article

Power BI

March 29, 2024 4 min read

Creating the Linear Gauge to Check the Status of Sales in Power BI

Microsoft Power BI offers an extensive range of charts and graphs designed to visually represent data, facilitating i...

Read Article

Power BI

March 26, 2024 4 min read

Enhancements in Column, Bar and Ribbon Charts in Power BI

Microsoft Power BI continues to be a cornerstone in the BI community, with its relentless commitment to updates cater...

Read Article

ADF

March 22, 2024 6 min read

Implementing ADF Branches and Filters for Employee Training

In one organization, there is one analysis of employee’s performance on different technologies based on the tec...

Read Article

Power BI

March 19, 2024 4 min read

Enhancements in the New Card Visual in Power BI

Microsoft is always keen to bring new updates to its reporting service Power BI. Because, it has a wide user base and...

Read Article

DAX

March 15, 2024 7 min read

Revolutionizing DAX with the Magic of Visual Calculation in Power BI

The February 2024 update marks a transformative shift in DAX in Power BI writing with the introduction of visual calc...

Read Article

Power BI

March 13, 2024 4 min read

Enhancing Column chart for Variance Analysis in Power BI: A Step-by-Step Guide

In the dynamic landscape of business analytics, tracking and comparing sales or profit variances across different cat...

Read Article

Power BI

March 6, 2024 5 min read

Implementing Dynamic Cascading Slicer To Filter the Data

Recently, for Power BI, we encountered a requirement where we have Delivery data, and we want Slicer which gives a ra...

Read Article

DAX

March 1, 2024 5 min read

Dynamic page navigation in Power BI based as per User Role

In Power BI, providing page security and role-based access to users traditionally involves creating different workspa...

Read Article

Dynamics 365 for Sales

February 27, 2024 4 min read

How to get direct count using Fetch XML capabilities

FetchXML in Dynamics 365 is a query language used to retrieve data from the system. It is a powerful and flexible too...

Read Article

Business Central

February 23, 2024 4 min read

Unlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API

Say hello to Databricks, a dynamic platform merging the power of Apache Spark with collaborative workspaces allowing ...

Read Article

Business Central

February 20, 2024 5 min read

Integration of Business Central APIs and Web Services with OAuth

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

Read Article

Business Blogs

February 19, 2024 6 min read

Is Microsoft Dynamics 365 Business Central the best ERP?

ERPs or Enterprise Resource Planning applications have been around for a very long time now. They started off as simp...

Read Article

Power BI

February 16, 2024 5 min read

Achieving Hierarchical Representation for Measures in Power BI Matrix Visual: A Workaround

Greetings, BI enthusiasts! When working with Power BI reports and handling numerical data with multiple hierarchies, ...

Read Article

Business Intelligence

February 13, 2024 3 min read

Add custom fonts in SSRS Report

Adding  custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visua...

Read Article

Logic Apps

February 6, 2024 4 min read

Parse JSON for Multi-Type Properties

JSON (JavaScript Object Notation) is a widely used data format for storing and exchanging data. It is easy to read, w...

Read Article

PowerApps

January 30, 2024 4 min read

Create apps from Figma in Power Apps

The ability to create PowerApps from Figma design files directly helps bridge the gap between design and development ...

Read Article

Business Blogs

January 24, 2024 5 min read

Streamlining Business Operations with Microsoft Dynamics 365 Business Central, Microsoft Power BI Consulting, and Power Apps Services

In today’s dynamic business landscape, organizations are constantly seeking innovative solutions to enhance the...

Read Article

Power BI

January 19, 2024 4 min read

Part 3: Git Integration for Content Management

In our previous blog, we delved into the inner workings of Deployment Pipelines. Now, we shift our focus towards a cr...

Read Article

Power BI

January 16, 2024 4 min read

Part 2: Streamlining Power BI Deployment Pipelines

In our previous blog post, we delved into Power BI Projects and Git integration, catering to the needs of developers ...

Read Article

Power BI

January 9, 2024 4 min read

Part 1: Git Integration with Power BI

In a much-anticipated move, Microsoft has unveiled Git Integration in Power BI for developers who work with Power BI ...

Read Article

Technical Blogs

January 5, 2024 2 min read

Email Deduplication In Customer Insights

The email deduplication in Customer Insights feature prevents sending of duplicate emails to the same email address, ...

Read Article

MS SQL Server

January 2, 2024 4 min read

Leveraging SQL Schema Compare in Visual Studio for Efficient Database Management

In the dynamic landscape of database management, maintaining and evolving database schemas is a critical aspect. Visu...

Read Article

Business Central

December 29, 2023 2 min read

Identify Posted Purchase Receipt and Invoices Against Purchase Order

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

Read Article

PowerApps Portal

December 26, 2023 4 min read

Power Pages Backup Using One Line PowerShell Script

The Power Page backup process is a very simple process using PowerShell. The command is a single line that combines t...

Read Article

Logic Apps

December 22, 2023 3 min read

Concurrency Control In Loop In Power Automate And Logic Apps

To understand concurrency control in loop of Power Automate Flow/Logic Apps, let us try to understand in this blog ab...

Read Article

Business Central

December 19, 2023 3 min read

Auto create Item In Business Central While Entering Item Description In Sales Line

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

Read Article

Dynamics 365 for Sales

December 15, 2023 3 min read

Sequence in Dynamics 365 Sales process

An email, phone conversation, task creation, or record update in the Dynamics 365 Sales system are examples of preset...

Read Article

Business Central

December 12, 2023 4 min read

How to Create Progress Indicator in Business Central using AL Code

If you want to know how to create a progress indicator in Business Central using AL Code, look no further. This blog ...

Read Article

Azure

December 5, 2023 4 min read

Copy Data Dynamically From Multiple Sources To Multiple Sinks In ADF

In this blog we are going to learn how to implement Dynamic Mapping to copy data from multiple sources to sinks in AD...

Read Article

Logic Apps

December 1, 2023 4 min read

Group by in Array/Collections in Power Automate/Logic Apps

Power Automate provides a versatile set of actions and expressions that allow you to craft logic to meet a wide range...

Read Article

PowerApps

November 28, 2023 4 min read

Side Pane in Model Driven App – Part1

There are some scenarios where users spend a lot of time in getting the overview of quick updates due to lack of unde...

Read Article

Business Blogs

November 21, 2023 4 min read

The Benefits of Power BI for Decision-Making

Consumerism is at an all-time high, especially after the economic lull in 2020. Since 2021, e-commerce sales have gro...

Read Article

Microsoft Flow

November 7, 2023 3 min read

Filter The Array/Collections Using Power Automate Or LogicApps

Can we filter the array/collections using Power Automate or LogicApps? Ever came across a situation where from a list...

Read Article

Business Central

November 3, 2023 3 min read

Make fields Non-editable in Business Central

If you want to make fields non editable in Business Central on a master page or on a transaction page, you depend on ...

Read Article

Dynamics 365 for Sales

November 1, 2023 3 min read

Role-Based Sitemap Navigation in Dynamics 365 CE

Different users’ access to different kinds of records is defined by their security roles. You can limit access ...

Read Article

Business Blogs

October 27, 2023 4 min read

Transforming Your Business Processes for Peak Performance: A Guide to IT Efficiency

In the ever-evolving landscape of the business world, staying ahead of the competition requires constant innovation a...

Read Article

Business Central

October 24, 2023 3 min read

Allow Selecting Multiple Customer/Vendor Posting Group in Business Central

At the time of transaction, the user can change Customer posting Group OR Vendor posting Group if needed as per the A...

Read Article