Power BI Archives • AugForums.com

Acumatica Comma-Separated List of Purchase Orders for a Vendor using Microsoft Excel

February 2, 2021 by Tim Rodman

You can use Microsoft Excel and OData in Acumatica to get a comma-separated list of Purchase Orders for a list of Vendors. … [Read more...]

Getting Actionable Information with Self-Service Reports & Dashboards – Summit 2019

January 28, 2019 by Tim Rodman

Acumatica Summit 2019 Session – Getting Actionable Information with Self-Service Reports & Dashboards (Tim Rodman) … [Read more...]

Power BI vs Tableau, Self-Service BI, and Hitler? Wait, what?!?

June 11, 2018 by Tim Rodman

This video showing "Hitler's reaction to Tableau" is hilarious. I liked it so much that I thought I would post it here and include a transcript. … [Read more...]

Introducing AUG, An Acumatica User Group

April 30, 2018 by Tim Rodman

Welcome to AUG, an Acumatica User Group. The AUG Forums are a place for Acumatica users to share information, talk about how much Sage Sucks, and generally just help each other out. … [Read more...]

Getting Started with Acumatica and Power BI – Part 3

March 31, 2018 by Tim Rodman

Getting Started with Acumatica and Power BI. In this example, analyzing your Acumatica Monthly Commercial Transactions and finding the highest Transaction Type Category across multiple Instances and Companies. … [Read more...]

Acumatica, Power BI, and a Water Fountain (Guest Post)

February 27, 2018 by Tim Rodman

Here's an example of how Acumatica data displayed next to a water fountain using Power BI is driving positive organizational behavior for an organization. … [Read more...]

Getting Started with Acumatica and Power BI – Part 2

December 19, 2017 by Tim Rodman

Getting Started with Acumatica and Power BI. In this example, finding unused inventory by displaying the inventory value with the last time it was ordered. … [Read more...]

Getting Started with Acumatica and Power BI – Part 1

October 31, 2017 by Tim Rodman

Getting Started with Acumatica and Power BI. In this example, comparing # of Customers, # of Invoice Lines, and Total Sales Amount in your Acumatica data. … [Read more...]

Initial Query Quarry Idea Killed by Acumatica 2017 R2 Out-of-the-Box Generic Inquiries

September 28, 2017 by Tim Rodman

The death of my initial Query Quarry idea is a good thing. The new Query Quarry direction is exclusively a Generic Inquiry Data Warehouse for Power BI. … [Read more...]

Query Quarry (Acumatica and Power BI)

August 31, 2017 by Tim Rodman

Are you using Acumatica? Have you heard about Power BI, but aren’t sure how to get started? Query Quarry helps you get started with Acumatica and Power BI. … [Read more...]