AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

acuCONNECT 2021 – Acumatica with Microsoft Excel, Power Query, and Power BI

November 3, 2021 by Tim Rodman

Thanks to everyone who attended my session at acuCONNECT 2021. You’ll find the stuff that I promised during the session here in this post.

acuCONNECT 2021

I presented a session at acuCONNECT 2021 on November 03, 2021 @ 1:15pm Eastern Time

Session Title: Acumatica with Microsoft Excel, Power Query, and Power BI

I only had 30 minutes so I was limited in what I could show. The intention of this post is to point you to some additional information.

I didn’t want to waste time on much of an introduction during the presentation. If you’d like to learn more about me and what I do here on AUGForums.com, checkout this acuCONNECT 2021 Session Introduction podcast episode:

Click here for Podcast Episode #55 Related Links

My 30 minute presentation at acuCONNECT 2021 was a scaled down version of this 70 minute YouTube Live presentation (click here) so feel free to watch that if you’d like to see how I built the example that I reviewed during my acuCONNECT 2021 presentation.

In that presentation I mention this What is Power BI Blog Post (click here) which gives the history of Power BI, how Power BI (called PowerPivot at the time) started in Microsoft Excel long before PowerBI.com (click here) ever existed, and how Power BI is the best thing to happen to Excel in 20 years.

If you’d like to download the Excel file and Generic Inquiry that I used during this presentation, you can do so below. Just note that you need to be logged in or you’ll see a “Content Restricted” message below.

Content Restricted to Members

To access this content, either Login (click here) or Request Your Free Account (click here)

Filed Under: Acumatica Learning Tagged With: acu-connect, Acumatica, Acumatica Blog, Acumatica Learning, Acumatica Training

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • EP 166: Tim uses ChatGPT and Claude to build something cool (Podcast) March 21, 2026
  • EP 165: Jake Wells – EOS Scorecard and Acumatica Dashboards (Podcast) March 12, 2026
  • EP 164: Phil Steichen – Vibe Coding your own Business Intelligence tool (Podcast) February 19, 2026
  • EP 163: Daryl Bowman – Dissecting the new Acumatica Calendar Board (Podcast) February 9, 2026
  • EP 162: Gabriel Michaud – Catching up on new cool stuff in Velixo and Excel (Podcast) February 2, 2026

Recent Forum Posts

  • Ed Dolan

    Negative/Credit Inventory Value?

    We are starting a new line of business to recycle const...

    By Ed Dolan , 3 days ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodmanrodman Question for you. What table joins d...

    By Tami , 2 weeks ago

  • Brynn Rutherford

    RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    @timrodman - It won't let me attach the file. I will em...

    By Brynn Rutherford , 2 weeks ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Thank you! We just upgraded to 2025R1 in ...

    By Tami , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    @tlynn Looks like someone already created a product ide...

    By Tim Rodman , 2 weeks ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Yes! If that parameter was optional it wo...

    By Tami , 2 weeks ago

  • Tim Rodman

    RE: Can not delete an automated schedule

    I doubt it since Business Events are stored on the Busi...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    Is the problem with this Critical Materials (AM401000) ...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Update the Unit Rate for Existing Project Templates

    The following worked for me.   Here's the Data...

    By Tim Rodman , 2 weeks ago

Terms of Use & Disclaimers :: Privacy Policy

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