AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica OData wit...
 
Notifications
Clear all

Acumatica OData with Microsoft Excel and Power BI

Questions or knowledge sharing about using OData in Acumatica to connect Generic Inquiries directly to Microsoft Excel or Power BI.
RSS
Status
Author
Topics
Forum
Replies
Views
Last Post 
scooter
Questions Embedding Power BI Reports in Acumatica - Reply Address Error
By scooter, Jan 29, 18 
  Acumatica OData with Microsoft Excel and Power BI
24
24 K
Kurt Keating
By Kurt Keating
11 months ago
Tim Rodman
#AcumaticaTnT Making OData Faster
By Tim Rodman, Mar 10, 22 
  Acumatica OData with Microsoft Excel and Power BI
6
2,109
Joni Girardi
By Joni Girardi
1 year ago
Kurt Keating
Questions Odata / PowerBI Error
By Kurt Keating, Sep 07, 23 
  Acumatica OData with Microsoft Excel and Power BI
2
878
Kurt Keating
By Kurt Keating
2 years ago
Brett Clark
Questions Power BI Measure to Calculate Sales for a Specific Department
By Brett Clark, Aug 04, 23 
Topic Tags:  Power BI ,
  Acumatica OData with Microsoft Excel and Power BI
0
899
Brett Clark
By Brett Clark
2 years ago
Patrick Sullivan
Questions Refreshing Odata GI TAbles in Excel not showing newly created GIs with Expose via OData selected
By Patrick Sullivan, May 11, 23 
Topic Tags:  OData , Excel , GI ,
  Acumatica OData with Microsoft Excel and Power BI
4
910
Patrick Sullivan
By Patrick Sulliv...
2 years ago
Brett Clark
Questions OData Error when Pulling into Power BI
By Brett Clark, Jul 18, 23 
Topic Tags:  OData , Error ,
  Acumatica OData with Microsoft Excel and Power BI
2
844
Brett Clark
By Brett Clark
2 years ago
Patrick Sullivan
Questions connecting Acumatica to Google Sheets via Odata feed
By Patrick Sullivan, Apr 17, 23 
Topic Tags:  OData , Google ,
  Acumatica OData with Microsoft Excel and Power BI
0
1,182
Patrick Sullivan
By Patrick Sulliv...
2 years ago
Radoy Davidov
Questions Can you authenticate with Active Directory user
By Radoy Davidov, Oct 20, 22 
  Acumatica OData with Microsoft Excel and Power BI
3
1,149
Gabriel Michaud
By Gabriel Michau...
3 years ago
Taylan
Questions OData Request Failed - Error 500
By Taylan, Apr 30, 19 
  Acumatica OData with Microsoft Excel and Power BI
3
3,762
ArrieD
By ArrieD
3 years ago
jmasi
Questions Getting Error: DataFormat.Error: OData: The format 'text/html; charset=utf-8' is not supported. Details: text/html; charset=utf-8
By jmasi, May 06, 19 
  Acumatica OData with Microsoft Excel and Power BI
4
6,021
Matt Kahn
By Matt Kahn
3 years ago
Hazen Metro
Questions Odata Feed in 2020 R1
By Hazen Metro, Nov 12, 20 
  Acumatica OData with Microsoft Excel and Power BI
3
1,922
Richard Whight
By Richard Whight
3 years ago
Tim Rodman
Questions A New Way to Embed Power BI Reports in Acumatica
By Tim Rodman, Jan 24, 19 
Topic Tags:  acumatica user group ,
  Acumatica OData with Microsoft Excel and Power BI
11
7,756
Tim Rodman
By Tim Rodman
4 years ago
daniel
Questions Creating a live dashboard on PowerBI or Excel Online
By daniel, Aug 30, 18 
  Acumatica OData with Microsoft Excel and Power BI
10
3,577
Tim Rodman
By Tim Rodman
4 years ago
Arline Welty
Questions PowerBI: XML to see all GIS works great. But in PowerBI, credentials fail.
By Arline Welty, Jun 22, 21 
  Acumatica OData with Microsoft Excel and Power BI
3
1,628
Tim Rodman
By Tim Rodman
4 years ago
Siva Katakam
Questions Issue while connecting Acumatica from powerbi
By Siva Katakam, May 28, 20 
  Acumatica OData with Microsoft Excel and Power BI
2
1,100
Tim Rodman
By Tim Rodman
4 years ago
Questions Excel Odata - Underlying Connection was closed.
By FMG18, Dec 17, 19 
Topic Tags:  Excel , OData ,
  Acumatica OData with Microsoft Excel and Power BI
4
2,488
staceypoll
By staceypoll
4 years ago
Tim Rodman
#AcumaticaTnT Creating Parameters in Excel that restrict data returned from Acumatica
By Tim Rodman, Jun 11, 21 
  Acumatica OData with Microsoft Excel and Power BI
1
2,348
Alec Clawson
By Alec Clawson
4 years ago
animal
#AcumaticaTnT Applying Filters in OData
By animal, Nov 24, 17 
  Acumatica OData with Microsoft Excel and Power BI
9
11.8 K
Tim Rodman
By Tim Rodman
4 years ago
Tim Rodman
#AcumaticaTnT Acumatica and Excel OData Credentials on Local Computer
By Tim Rodman, Jun 11, 21 
  Acumatica OData with Microsoft Excel and Power BI
1
2,344
davidhunter
By davidhunter
4 years ago
Sweed
Questions OData connection works, but data is empty! Returns Column Headers only.
By Sweed, Feb 19, 21 
  Acumatica OData with Microsoft Excel and Power BI
5
3,054
Sweed
By Sweed
4 years ago
Jeffrey Patch
#AcumaticaTnT Support for OData and Apple version of MIcrosoft Excel - Looks like its coming
By Jeffrey Patch, Mar 05, 21 
  Acumatica OData with Microsoft Excel and Power BI
1
1,186
Tim Rodman
By Tim Rodman
4 years ago
ZachKarpinski
Questions You do not have access to this entity set.
By ZachKarpinski, Aug 12, 20 
Topic Tags:  OData , site map , Generic Inquiry ,
  Acumatica OData with Microsoft Excel and Power BI
2
2,640
ZachKarpinski
By ZachKarpinski
5 years ago
Questions OData POST request returns 404 Not Found; error message: "No routing convention was found to select an action for the OData path with template '~/entityset'.
By Sabrina Rojba, Jan 20, 20 
  Acumatica OData with Microsoft Excel and Power BI
4
4,682
Tim Rodman
By Tim Rodman
5 years ago
Tim Rodman
#AcumaticaTnT OData Refresh Only Updated Records
By Tim Rodman, May 07, 19 
  Acumatica OData with Microsoft Excel and Power BI
2
4,491
Tim Rodman
By Tim Rodman
6 years ago
Hazen Metro
Questions ODBC Error in Power BI - Connection forcibly closed by remote host (1 viewing)
By Hazen Metro, Jul 30, 19 
  Acumatica OData with Microsoft Excel and Power BI
8
18.9 K
Tim Rodman
By Tim Rodman
6 years ago
Tim Rodman
#AcumaticaTnT Acumatica SaaS ODBC Access Retiring
By Tim Rodman, Oct 12, 18 
  Acumatica OData with Microsoft Excel and Power BI
4
2,551
Tim Rodman
By Tim Rodman
6 years ago
Tim Rodman
#AcumaticaTnT Tips for working with OData in Acumatica
By Tim Rodman, Mar 09, 19 
  Acumatica OData with Microsoft Excel and Power BI
0
2,644
Tim Rodman
By Tim Rodman
6 years ago
KBlas
Questions Error for certain users when refreshing data in Excel
By KBlas, Dec 28, 18 
Topic Tags:  Odata , Excel , GI ,
  Acumatica OData with Microsoft Excel and Power BI
6
7,806
Tim Rodman
By Tim Rodman
6 years ago
Tim Rodman
Questions 8. Power BI – % of New Sales - Summit 2019 Session Examples
By Tim Rodman, Jan 28, 19 
Topic Tags:  acumatica user group ,
  Acumatica OData with Microsoft Excel and Power BI
1
2,915
By Paola Hernande...
6 years ago
Tim Rodman
Questions 7. Exporting to Excel vs. OData - Summit 2019 Session Examples
By Tim Rodman, Jan 28, 19 
Topic Tags:  acumatica user group ,
  Acumatica OData with Microsoft Excel and Power BI
0
5,797
Tim Rodman
By Tim Rodman
6 years ago
KBlas
Questions Get Count of Customer with Sales YoY
By KBlas, Nov 14, 18 
  Acumatica OData with Microsoft Excel and Power BI
5
2,460
Tim Rodman
By Tim Rodman
7 years ago
Tim Rodman
Questions Using JSON with OData in Acumatica
By Tim Rodman, Oct 04, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
7,349
Tim Rodman
By Tim Rodman
7 years ago
Questions As of 2018 R2 what is the value of Power BI over built in Acumatica reporting and data view tools?
By Clark Walliser, Oct 26, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
2,039
Tim Rodman
By Tim Rodman
7 years ago
mhoss
Questions Error Setting up Power BI
By mhoss, Sep 15, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
2,541
Tim Rodman
By Tim Rodman
7 years ago
russ
Questions MAC and Odata
By russ, Aug 27, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
3,164
Tim Rodman
By Tim Rodman
7 years ago
Joni Girardi
Questions Acumatica UTC datetime imported into MS SQL via OData
By Joni Girardi, Aug 26, 18 
  Acumatica OData with Microsoft Excel and Power BI
2
2,738
Joni Girardi
By Joni Girardi
7 years ago
Questions OData queries and user sessions
By Jeff Lewis, Jun 21, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
3,500
Tim Rodman
By Tim Rodman
7 years ago
Saiful Murad
Questions Enforce a formatting from Acumatica
By Saiful Murad, Mar 11, 18 
  Acumatica OData with Microsoft Excel and Power BI
5
2,851
Saiful Murad
By Saiful Murad
7 years ago
russ
Questions Security -- Power BI
By russ, Feb 28, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
2,421
Tim Rodman
By Tim Rodman
7 years ago
fozzie
Questions Deleting a Power BI App Registration in Azure
By fozzie, Feb 17, 18 
  Acumatica OData with Microsoft Excel and Power BI
5
5,320
Tim Rodman
By Tim Rodman
7 years ago
Questions update data to Acumatica from Excel
By Kiran, Feb 14, 18 
  Acumatica OData with Microsoft Excel and Power BI
1
2,609
Tim Rodman
By Tim Rodman
7 years ago
SQLRunner
Questions Odata Fails... Sometimes
By SQLRunner, Jan 17, 18 
  Acumatica OData with Microsoft Excel and Power BI
10
27.4 K
Tim Rodman
By Tim Rodman
7 years ago
rowlf
Questions Connecting to Acumatica OData from Microsoft Excel
By rowlf, Jun 17, 17 
  Acumatica OData with Microsoft Excel and Power BI
3
11.2 K
fozzie
By fozzie
8 years ago
Brian Rowerdink
Questions Null Attribute
By Brian Rowerdink, Aug 04, 17 
  Acumatica OData with Microsoft Excel and Power BI
2
3,972
Tim Rodman
By Tim Rodman
8 years ago
POTATO_GHOST
Questions Adding Power BI Reports In Acumatica
By POTATO_GHOST, Jun 28, 17 
  Acumatica OData with Microsoft Excel and Power BI
14
6,523
Tim Rodman
By Tim Rodman
8 years ago
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,521 Topics
  • 10.9 K Posts
  • 14 Online
  • 2,321 Members
Our newest member: Courtney Wilder
Latest Post: Can UDFs be populated using an Import Scenario?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×