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

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

How to Dynamically Filter in Jet Reports Using a Drop Down-List

This blog provides step-by step instructions on how to create a dropdown list for end users to use to filter a Jet Report without the end user needing Jet Reports license. As a report designer, when working with Jet Global’s Jet Reports, it can be time consuming to create multiple versions of the same report… Continue reading How to Dynamically Filter in Jet Reports Using a Drop Down-List

Navigating and Optimizing Power BI for More Effective Reporting

Microsoft Power BI is a reporting and analytics tool that can analyze data from a myriad of sources, including Microsoft Dynamics NAV, Excel, Google Analytics, social networks, APIs, Odata feeds, and more. Power BI allows for creation of interactive KPIs, charts, graphs, matrices, and other visuals to product unique and meaningful reports you can use… Continue reading Navigating and Optimizing Power BI for More Effective Reporting

How to Set Custom Color Themes in Microsoft Power BI

When publishing internal and external reports for your business it is important to be consistent with your branding standards by using the same color schemes and logos. Microsoft Power BI it a great tool for creating and publishing dynamic and interactive reports and it allows for the customization of colors to match your brand standards.… Continue reading How to Set Custom Color Themes in Microsoft Power BI

Microsoft Power BI Map Visualizations Made Easy

Microsoft Power BI is a powerful tool that allows users to pull real time data directly from Microsoft Dynamics NAV and other sources for analysis and reporting. Included in the analyzation options are two map visualizations that show data by location. These maps are an impactful and creative way to display data. However, sometimes it… Continue reading Microsoft Power BI Map Visualizations Made Easy