Blogs

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

, December 13, 20242153 Views

As per the beginner’s knowledge, RPA (Robotic Process Automation) Desktop flows, also known as UI flows, are a feature within Microsoft Power Automate that allows users to automate repetitive tasks on their Windows desktop or web applications. Desktop flows are part of the broad Power Automate platform, providing a solution for automating processes that involve… Continue reading Unlocking Efficiency: A Beginner’s Guide to RPA Desktop Flows in Power Automate

Read more

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

, December 10, 2024873 Views

Maintaining organized and meaningful data is crucial for effective management and analysis. AutoNumber fields are a popular solution for generating unique identifiers, but sometimes a simple numeric sequence isn’t enough. By adding prefixes based on specific conditions, you can enhance the context of your data, making it easier to identify and categorize records briefly. In… Continue reading How to Populate Prefix in AutoNumber fields based on conditions in Dynamics 365 Sales

Read more

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

, December 6, 20241015 Views

As everybody knows, in Dataverse, if we need to do anything that is not available in OOTB functionality and crucial to implement, we need to use plugin. To write a plugin, we need to write a code to mitigate our functionalities. But now, we do have another option available that will help us to create… Continue reading How to use Low-No Code Plugin using Data verse accelerator in dynamics 365

Read more

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

, December 3, 2024855 Views

These days a speedy-paced business environment and efficient reporting equipment are crucial. Dynamics 365 is a powerful CRM and ERP answer that offers robust reporting capabilities. However, exporting those reports in a consumer-friendly format, like PDF, can on occasion be difficult. Fortunately, Power Automate gives a streamlined way to automate this method. In this blog,… Continue reading How to run OOTB Report and send emails with pdf attachments using Power Automate.

Read more

Split the Text files using ADF Pipelines

, November 29, 2024603 Views

Requirements: If the file size of an Excel file exceeds the specified criteria, we need to address the following: The Excel file contains multiple sheets, and these sheets contain inter-related data. We utilize SQL Views to retrieve data from these sheets using the “Get Data” activity in Excel. Although we can split the Excel file… Continue reading Split the Text files using ADF Pipelines

Read more

Hello world!

, November 29, 2024259 Views

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Read more

How Microsoft Power BI Services are Better Than Excel: An Informative Guide for Business Owners and Beginners

, November 26, 20241108 Views

For many years, Microsoft Excel has been a trusted tool for managing data, creating charts, and performing calculations. It’s often one of the first tools people reach for when working with numbers and has a special place in nearly every business. However, as businesses grow, so does the need for more powerful tools. Enter Microsoft… Continue reading How Microsoft Power BI Services are Better Than Excel: An Informative Guide for Business Owners and Beginners

Read more

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

, November 19, 2024605 Views

Power Apps, known for its low-code/no-code capabilities, now offers the ability to create complete apps from an image. Sometimes, the best way to design an app starts with something as simple as a pen and paper. Whether you’re in a meeting, brainstorming with your team, or just working through ideas on your own, sketching out… Continue reading Paper to Power App: Creating a Canvas App in D365 CRM from a Hand-Drawn Sketch

Read more

The Benefits of Moving to Microsoft Fabric: What Every Leader Should Know

, November 15, 2024701 Views

As the digital world continues to evolve, business leaders face constant pressure to make technology decisions that will position their organizations for success. One of the most critical decisions today is choosing the right data and analytics platform—one that is flexible, secure, cost-effective, and built for the future. Microsoft Fabric has emerged as a powerful,… Continue reading The Benefits of Moving to Microsoft Fabric: What Every Leader Should Know

Read more

How Microsoft Fabric Helps You Make Data-Driven Decisions Without the Tech Jargon

, November 12, 2024427 Views

In today’s fast-paced business world, making decisions backed by data is essential. But for many decision-makers, accessing useful insights can be challenging because data tools often require technical expertise. This is where Microsoft Fabric steps in. Microsoft Fabric is a data analytics platform designed to make understanding and using data easy for everyone—especially those who… Continue reading How Microsoft Fabric Helps You Make Data-Driven Decisions Without the Tech Jargon

Read more

5 Ways Microsoft Fabric Can Improve Your Business Operations

, November 8, 2024415 Views

In today’s fast-paced business world, efficiency, informed decision-making, and seamless collaboration are key to staying competitive. Microsoft Fabric, a modern data platform, brings all these benefits together by unifying analytics, storage, and collaboration in one place. Here’s how Microsoft Fabric can positively impact your business operations and empower your team, even if you aren’t tech-savvy.… Continue reading 5 Ways Microsoft Fabric Can Improve Your Business Operations

Read more

The Real Cost of Data Silos: Why Microsoft Fabric is Essential for Unified Data Access

, November 5, 2024427 Views

In today’s fast-paced world, data is at the heart of business success. Whether you’re running a small business or a global corporation, your data has the potential to unlock valuable insights, drive smarter decisions, and keep you one step ahead of the competition. However, many companies face a common but critical roadblock that keeps their… Continue reading The Real Cost of Data Silos: Why Microsoft Fabric is Essential for Unified Data Access

Read more

Why Business Central is the Smarter Choice for Financial Control and Cost Management

, October 29, 2024416 Views

In today’s fast-paced business world, financial control and cost management are at the core of every successful company. Without a clear view of finances, businesses can find themselves overspending, missing financial opportunities, or struggling to compete. Microsoft Dynamics 365 Business Central is a powerful tool that’s helping businesses make smarter financial decisions, save money, and… Continue reading Why Business Central is the Smarter Choice for Financial Control and Cost Management

Read more

Why Business Central’s Features Go Beyond Basic Accounting Solutions

, October 25, 2024423 Views

When businesses consider upgrading their accounting software, they often look for a solution that manages their finances smoothly, keeps their records accurate, and complies with tax regulations. Microsoft’s Business Central offers all of that—and so much more. But why does Business Central stand out, especially for companies looking for more than just accounting software? Let’s… Continue reading Why Business Central’s Features Go Beyond Basic Accounting Solutions

Read more

Top 5 Growing Pains of Small Businesses and How Business Central Solves Them

, October 22, 2024715 Views

Growing a small business is an exciting journey, but with growth comes challenges, or what many call “growing pains.” These growing pains can hold businesses back if they’re not addressed properly. Fortunately, tools like Microsoft Dynamics 365 Business Central (BC) can help ease these struggles and set businesses up for long-term success. In this blog… Continue reading Top 5 Growing Pains of Small Businesses and How Business Central Solves Them

Read more

How Power BI Mobile Keeps You Connected to Your Business Data from Anywhere

, October 18, 2024366 Views

In today’s fast-paced business world, staying informed is more important than ever. Whether you’re managing a team, overseeing multiple projects, or making critical decisions, having quick and easy access to your business data can make all the difference. That’s where Power BI Mobile comes in. It’s a powerful tool that keeps you connected to your business… Continue reading How Power BI Mobile Keeps You Connected to Your Business Data from Anywhere

Read more

Streamlining Team Collaboration with Power BI: Shared Dashboards and Reports

, October 15, 2024636 Views

In today’s fast-paced business environment, effective collaboration among team members is essential for making informed decisions. One powerful tool that can enhance collaboration is Power BI by Microsoft. In this guide, we’ll explore how Power BI can streamline team collaboration through shared dashboards and reports, even for those who may not be tech-savvy. Why Use… Continue reading Streamlining Team Collaboration with Power BI: Shared Dashboards and Reports

Read more

Real-Time Data Monitoring with Power BI: How to Make Data-Driven Decisions Faster

, October 11, 2024896 Views

In today’s fast-paced business environment, timely decisions are crucial. Whether it’s responding to market shifts, managing operations, or improving customer satisfaction, staying on top of your data can give you a significant edge. But how can you make sure you’re seeing the most up-to-date information, and how can you turn that into action? That’s where… Continue reading Real-Time Data Monitoring with Power BI: How to Make Data-Driven Decisions Faster

Read more

How to render lookup as dropdown in Powerpage

, October 1, 20241913 Views

In today’s digital landscape, creating user-friendly interfaces is essential, especially when building applications using Microsoft Power Portal. One common requirement is to render lookup fields as dropdown menus, enabling users to select from a predefined set of values. This functionality enhances the user experience by making data entry more intuitive and efficient. In this blog,… Continue reading How to render lookup as dropdown in Powerpage

Read more

Discover the Magic of Q&A Visual in Power BI!

, September 27, 2024834 Views

Imagine being able to ask your data questions as easily as you’d ask a colleague, and in seconds, getting the answers neatly organized in the form of charts, graphs, or tables. so That’s the beauty of Power BI’s Q&A Visual! It’s like chatting with your data, no technical know-how required. Curious how it works? Let’s… Continue reading Discover the Magic of Q&A Visual in Power BI!

Read more

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

, September 27, 20242518 Views

This  Power Automate Flow fetches Name and Email-address of the Person/(s) mentioned in the ‘From’, ‘To’, ‘CC’, ‘BCC’ mappings of the Outlook Online for a user-defined time-period i.e., Start Date and End Date and outputs the data in a Notepad .txt file in Outlook Online to a specific user-defined person email. What are the input… Continue reading Use Power Automate to get Name and Email Address in Outlook Online

Read more

Invoker’s Connection in Power Automate

, September 24, 20241355 Views

We’ve been using Power Automate extensively to automate operations in Dynamics 365 using the Dataverse connectors. Also, working with connectors in Microsoft Dataverse, using a connection reference is generally a good practice. However, there’s an exception: if you want to perform a Dataverse operation in the context of the person who triggers the flow (the… Continue reading Invoker’s Connection in Power Automate

Read more

Introduction to Data Science in Microsoft Fabric

, September 10, 2024588 Views

As an end-to-end SaaS Microsoft Fabric multiple workloads or components including Data Science. In this blog we will explore how Microsoft Fabric can be used to empower users with end-to-end data science workflows to enrich data and extracts business insights. What is Data Science? Data Science has become a popular term and buzzword in many… Continue reading Introduction to Data Science in Microsoft Fabric

Read more

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

, September 6, 20241178 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to manage posting restrictions on sales and purchase documents according to various users is pivotal for ensuring data integrity and financial control within organizations. Requirement: How can we effectively… Continue reading Managing Posting Restrictions on Sales/Purchase Document According to various users in MS Dynamics 365 Business Central

Read more

Comparing Business Central and QuickBooks: A Comprehensive Overview

, September 2, 2024501 Views

Choosing the right accounting software is crucial for managing finances and operations efficiently. Two popular options are Microsoft Business Central and Intuit QuickBooks. While both offer robust features, they cater to different business needs. Here’s a comparison highlighting their key differences and why Business Central might be a better fit for growing enterprises. Target Audience… Continue reading Comparing Business Central and QuickBooks: A Comprehensive Overview

Read more

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

, August 30, 20241593 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central. Prerequisites Access to… Continue reading How to create a QR Code that is the Base64 encoded TLV (Tag, Length, Value) in Dynamics 365 Business Central

Read more

Power BI vs. Tableau: A Comprehensive Comparison

, August 30, 2024791 Views

Choosing the right data visualization tool is essential for any business aiming to make data-driven decisions. Power BI and Tableau are two of the most popular options available, each with its own set of strengths. This article provides a concise comparison to help you determine which tool might best suit your needs, highlighting areas where… Continue reading Power BI vs. Tableau: A Comprehensive Comparison

Read more

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

, August 21, 2024924 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to Cancel Multiple Posted Sales Invoices in a batch using Job Queue in Business Central. A job queue in Microsoft Dynamics 365… Continue reading Cancel Multiple Posted Sales Invoices using Job Queue in MS Dynamics 365 Business Central using AL Code

Read more

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

, August 16, 20242068 Views

As Azure Data Factory (ADF) does not offer Excel as a sink option, an alternative method is required to copy Excel files using ADF pipelines. Implementation Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field list to include… Continue reading Copying Excel files from source to destination in Excel format using ADF Pipeline

Read more

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

, August 13, 20241460 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to create a custom job queue to create Sales order from Purchase order in Business Central. A job queue in Microsoft Dynamics… Continue reading Creating a Custom Job Queue to create Sales order from Purchase order in MS Dynamics 365 Business Central using AL Code

Read more

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

, August 2, 20241415 Views

The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data activity in Azure Data Factory (ADF) pipeline. Implementation: Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field… Continue reading Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF

Read more

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

, July 30, 20241325 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code. Integrating Power Automate Flows… Continue reading How to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code

Read more

Public Transport and Information Technology

, July 19, 2024466 Views

Public transport forms the blood vessels of a city with its citizens forming the precious life blood. They transport their precious cargo just like blood vessels in a body keeping the city alive and thriving. Any kind of disruption brings the city to a painful and grinding halt. While proper processes and experience can and… Continue reading Public Transport and Information Technology

Read more

Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central

, July 16, 2024664 Views

Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to archive projects (jobs) which can help keep your workspace organized and efficient. With archiving capabilities, users can manage their project data effectively, benefiting from audit trails and version… Continue reading Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central

Read more

Microsoft Power BI consulting: Introduction to the new Button Slicer

, July 3, 2024879 Views

The Power BI has introduced a new button slicer which resembles somewhat to the custom slicer, i.e., the Chiclet slicer. In this blog, as a part of Microsoft Power BI consulting we are going to explore this new button slicer. In the current report, we have imported the sample dataset i.e., Financials dataset, upon which… Continue reading Microsoft Power BI consulting: Introduction to the new Button Slicer

Read more

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

, June 27, 2024891 Views

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to get linked Sales order’s data in Assembly Order. This customization can be used for businesses that deal with complex assembly processes and… Continue reading Dynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code

Read more

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

, June 19, 20241173 Views

In this blog, we are going to explore the new feature to use the Calculation Groups using Power BI Desktop and Microsoft Power BI Services through Microsoft Power BI consulting. Currently, we are making use of the Sample dataset i.e., Financials dataset in Power BI. Also, we have created a Date table starting from minimum… Continue reading Microsoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).

Read more

Dynamics 365 Business Central

, June 10, 2024469 Views

Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to link Dimensions to a custom table and its Pages in D365 Business Central. Prerequisites Access to a Microsoft Dynamics 365 Business Central… Continue reading Dynamics 365 Business Central

Read more

Power Automate: Track Multiple Microsoft Survey Forms Responses

, June 4, 20241622 Views

In the realm of Microsoft Forms and Power Automate integration, “When a new response is submitted” connector serves as a reliable tool for triggering actions upon the submission of a single form response. However, a notable limitation arises when attempting to capture responses from multiple Microsoft Forms simultaneously. Considering this challenge, there emerges a need… Continue reading Power Automate: Track Multiple Microsoft Survey Forms Responses

Read more

Microsoft Power BI Consulting: Unleashing the Power of Generative AI

, May 28, 2024788 Views

In the ever-evolving landscape of data analytics and reporting, Microsoft continues to raise the bar with innovative solutions. One such groundbreaking feature is the integration of generative AI into its reporting platform, Power BI. With the Premium Capacity subscription, users can now harness the capabilities of Copilot to effortlessly create and modify reports with just… Continue reading Microsoft Power BI Consulting: Unleashing the Power of Generative AI

Read more