AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

Power Update

May 17, 2016 by Tim Rodman

You can point Power Update to individual Excel files or entire folders full of Excel files, then tell Power Update to publish out to Excel Online.

Last Summer we looked at how to take an Excel report and upload it to Excel Online (click here) so that users can use the report without needing to open it on their desktop computer. The problem is that a user has to run the report manually if they want to get up-to-date information.

In my experience, many report users don’t care to see data that is as current as today. They are fine with the data being as current as, say, last night. Rather than opening a report and having to click a button for it to refresh the data, many users would rather see refreshed data from the night before already looking at them in the report.

Unfortunately, you cannot yet schedule an Excel Online report to refresh itself on some kind of interval. At least not that I’m aware of. If you know of a way, please, please, please post it in the comments.

But I do know that you can do this with a utility called Power Update.

Power Update

Power Update is a simple application that sits on your desktop and can be downloaded and installed without any help from IT.

To learn more about Power Update, click here, click here, and click here.

Power Update was even used by Microsoft when competing against Tableau, Qlik, and Microstrategy at the recent Gartner BI and Analytics Summit. Click here to read about it.

You can point Power Update to individual Excel files or entire folders full of Excel files, then tell Power Update to publish the refreshed versions of those Excel files out to Excel Online. You can also have it publish the refreshed versions to other file folders or network shared file folders on your corporate intranet. I like the option of publishing to Office 365 because it allows us to leverage the Excel Online application for viewing the reports.

This feels like a much more modern experience for the user of the report and you can use Power Update on any Excel file with any data source, not just one that uses Acumatica OData connections. You can use it on an Excel file that’s pointed to SharePoint, pointed to a Database, pointed to Access, pointed to other Excel files, pointed to CSV files, etc.

If you would like to download Power Update to try it out, you can simple click the button below. Power Update is free and can be installed on any computer.

Download Power Update

However, the restriction is that each computer is only allowed to refresh one Excel workbook. If you want to install Power Update on 10 computers in you office, each computer can schedule the update of one Excel workbook. Alternatively, you could add many worksheets in your one Excel workbook and still use the free version of Power Update.

If you would like to refresh more than one Excel Workbook on a computer with Power Update, you simply need to pay the $500 license fee.

So feel free to try it out and, if you find that you want to refresh more than one Excel Workbook, I think you will find that it is well worth the $500 price tag.

O ya, and I personally used Power Update when I worked at The Robbins Company. It worked great and was very reliable. The managers loved having up-to-date metrics and I loved not having to spend my mornings refreshing Excel files. Click here to read more about my experience.

The combination of Acumatica, Excel Online, and Power Update has a lot of potential to get meaningful information into the hands of decision-makers without needing to purchase an expensive BI solution. And you can leverage your organization’s current Excel skills as well.

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica BI, Acumatica Blog, Acumatica Dashboards, Acumatica Generic Inquiry, Acumatica Learning, Acumatica OData, Acumatica Reporting, Acumatica Training, Business Intelligence, ERP, Power BI, Power Pivot, Power Query, Power Update

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I have the same issue and I use SubReport (in your case...

    By Idrus, 6 hours ago

  • RE: Is the Parameter Schema Field Mandatory?

    I think it's required. Without it, Acumatica doesn't kn...

    By Tim Rodman, 8 hours ago

  • RE: Can a customer Cross Reference for a parent account feed automatically to child accounts?

    @daniel I always like going simpler myself whenever pos...

    By Tim Rodman, 8 hours ago

  • RE: Carrier VDA Shipping Label (VDA 4994)

    Someone out there might have one, but I don't unfortuna...

    By Tim Rodman, 8 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I am attempting several different methods. The issue i...

    By Rick Taylor, 14 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    Are you just putting all the text in a single text box ...

    By megan.friesen, 15 hours ago

  • RE: Kensium Shopify versus Acumatica Shopify

    Hi Carl, Acumatica purchased the Shopify Connector, B...

    By Tyler Mullen, 18 hours ago

  • How to add multiple pages of contract terms to the Sales Order printed form

    The customer would like to add their contract terms to ...

    By Rick Taylor, 20 hours ago

  • Fixed Assets - Errors in Imports - Errors in posting - Can client return to blank FA DB?

    We have a client that has been through their implementa...

    By steven@ibs, 21 hours ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.