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
Category: How To Power BI
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 an excellent tool for creating and publishing dynamic and interactive reports, but it has a few tricky quirks. When creating a Power BI report with a table containing measures, sometimes the columns don’t total correctly. Those who experience this hurdle may be unfamiliar with how Power BI works or are new to data analysis expressions. Perhaps… 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