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

  • Acumatica Summit 2026 – Day 1 Keynote (Seattle, WA) January 26, 2026
  • EP 161: Arline Welty – Evaluate Acumatica with YOUR DATA before you buy (Podcast) January 12, 2026
  • EP 160: How long does it take an Automation Schedule to run in Acumatica (Podcast) November 7, 2025
  • EP 159: Mark Safran – Smartsheet Dashboards with Acumatica data (Podcast) October 29, 2025
  • EP 158: Garrett Rochell – Acumatica Upgades, especially with the Modern UI (Podcast) October 4, 2025

Recent Forum Posts

  • Julie Baker

    RE: Credit Reference Report Needed

    @pmkohler Patrick, did you ever get this working? I wou...

    By Julie Baker , 16 hours ago

  • John Rygielski

    Tax on Inventory Transfer

    Our clients are in the Oil & Gas industry. There ar...

    By John Rygielski , 2 weeks ago

  • Brynn Rutherford

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

    Hi, We have a Fixed Asset Generic Inquiry that combin...

    By Brynn Rutherford , 3 weeks ago

  • Lunar Windbloom

    RE: Feeling Stuck on Making a Sandbox of our Database

    @timrodman @toonsix Thank you! I need to figure out why...

    By Lunar Windbloom , 4 weeks ago

  • Tim Rodman

    RE: Attribute Input Mask

    Regular Expressions are a standard Linux thing and you ...

    By Tim Rodman , 4 weeks ago

  • Tim Rodman

    RE: Feeling Stuck on Making a Sandbox of our Database

    Ya, if you can't get the size down by deleting the snap...

    By Tim Rodman , 4 weeks ago

  • Tim Rodman

    RE: What Triggers a Customization to need a Restart?

    @tlaird self-hosting totally makes sense to me for peop...

    By Tim Rodman , 4 weeks ago

  • Tim Rodman

    RE: Invoice subreport for line-level tax breakdown not tieing to taxes subtotal

    It's not really an Acumatica problem huh; it's a math p...

    By Tim Rodman , 2 months ago

  • Rob Neal

    Invoice subreport for line-level tax breakdown not tieing to taxes subtotal

    We have a customer with a modified SO invoice form that...

    By Rob Neal , 2 months 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.