Category: Power BI

ArcherPoint’s Most Popular Content in 2023

Every year, the experts at ArcherPoint work hard to provide informative content that covers a wide range of topics of interest to Microsoft Dynamics 365 Business Central users, from How-To blogs that show you how to accomplish specific tasks in Business Central to technical articles that explain how things work under the hood in Business… Continue reading ArcherPoint’s Most Popular Content in 2023

Combining Jet Reports/Analytics with Power BI to Supercharge Your Reporting and Business Intelligence

Many Microsoft Dynamics 365 Business Central or Dynamics NAV users might be confused when considering reporting and analytics options. Popular options include Jet Reports, Jet Analytics, and Power BI. Which is the best choice? Each tool was designed for a specific purpose; therefore, it depends on what you want to do that will help determine… Continue reading Combining Jet Reports/Analytics with Power BI to Supercharge Your Reporting and Business Intelligence

How to Expand Power BI Alerts with Microsoft’s Power Automate

Alex Wiley, a PreSales Consultant at ArcherPoint, offers a six-minute video on Power BI Alerts and how this invaluable tool can be extended by Power Automate to create General/Ledger (G/L) alerts. Wiley discusses the requirements needed for alerts and how the alerts rely on the Power BI Service, which isn’t available with the BI Report… Continue reading How to Expand Power BI Alerts with Microsoft’s Power Automate

Create a Power Automate App for Machine Event Reporting and Export to SharePoint List

Jessie Wang, a Dynamics 365 Consultant at ArcherPoint, provides a video demonstration on how to use a Power Automate App for machine event reporting on the shop floor, record events from multiple work centers, and exporting plant floor data to SharePoint Lists. The video details the benefits of Power Automate, and how it allows you… Continue reading Create a Power Automate App for Machine Event Reporting and Export to SharePoint List

When Your IT partner Doesn’t Know Your Systems: What Could Happen, and How to Prevent It from Happening

We’ve seen it many times with many companies: The IT team decides to make updates to an application, operating system, or platform without first checking to see how that update will affect other systems—and something “breaks.” The fact is, one team doesn’t necessarily know what another team is doing, the tools they’re using, or how… Continue reading When Your IT partner Doesn’t Know Your Systems: What Could Happen, and How to Prevent It from Happening

Microsoft’s New Commerce Experience: What It Means for Customers

What Is Microsoft’s New Commerce Experience (NCE)? Microsoft has announced and will start rolling out in January 2022 its New Commerce Experience. What is NCE? Simply put, it is a new pricing model. Microsoft’s goal is to simplify the buying experience for all of their business customers. Over the years, as Microsoft has developed and acquired… Continue reading Microsoft’s New Commerce Experience: What It Means for Customers

BI Tools for Dynamics Business Central and NAV: Which One Is Right for You?

Today, the business world is user-centered, with self-service reporting available to allow decision makers to get their reports the way they want them. The question is, which business intelligence tools (BI) are the best? In this article, we take a closer look at BI tools for Microsoft Dynamics 365 Business Central (BC) and Dynamics NAV.… Continue reading BI Tools for Dynamics Business Central and NAV: Which One Is Right for You?

Retail KPIs: Why They’re Important and How to Decide What You Should Be Measuring

As we reach the end of a very unpredictable summer and pass the half-way point in the year, a great way to help finish 2021 strong along with adapting to new trends is to dive into measurables—the key performance indicators (KPI) that make sure your business is still on the path to your goals for the year, as well as preparing you for the months beyond. While there is no one right list of KPIs because each retailer should be measuring different things based on a number… Continue reading Retail KPIs: Why They’re Important and How to Decide What You Should Be Measuring

How to Make Measures Total Correctly in Power BI Tables

Microsoft Power BI is a great tool for creating and publishing dynamic and interactive reports, but it has a few quirks that can be tricky to navigate. When creating a Power BI report with a table that contains Measures, sometimes the columns in the table don’t total correctly. When a Measure is used on rows… Continue reading How to Make Measures Total Correctly in Power BI Tables