Acumatica Forums

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

Notifications

Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

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.

Status

Topics

Replies

Views

Users

Date

Questions OData Request Failed - Error 500

3

1,860

May 19

May 19

Questions Getting Error: DataFormat.Error: OData: The format 'text/html; charset=utf-8' is not supported. Details: text/html; charset=utf-8

4

2,413

Mar 17

Mar 17

#AcumaticaTnT Making OData Faster

4

223

Mar 16

Mar 16

Questions Odata Feed in 2020 R1

3

599

Feb 23

Feb 23

Questions A New Way to Embed Power BI Reports in Acumatica

Topic Tags: acumatica user group,

11

4,464

Nov 15

Nov 15

Questions Creating a live dashboard on PowerBI or Excel Online

10

1,539

Oct 19

Oct 19

Questions PowerBI: XML to see all GIS works great. But in PowerBI, credentials fail.

3

571

Jun 24, 21

Jun 24, 21

Questions Issue while connecting Acumatica from powerbi

2

569

Jun 24, 21

Jun 24, 21

Questions Excel Odata - Underlying Connection was closed.

Topic Tags: Excel, OData,

4

1,280

Jun 18, 21

Jun 18, 21

#AcumaticaTnT Creating Parameters in Excel that restrict data returned from Acumatica

1

754

Jun 14, 21

Jun 14, 21

#AcumaticaTnT Applying Filters in OData

9

6,899

Jun 11, 21

Jun 11, 21

#AcumaticaTnT Acumatica and Excel OData Credentials on Local Computer

1

698

Jun 11, 21

Jun 11, 21

Questions OData connection works, but data is empty! Returns Column Headers only.

5

664

Apr 12, 21

Apr 12, 21

Questions Embedding Power BI Reports in Acumatica - Reply Address Error

23

19.3 K

Mar 15, 21

Mar 15, 21

#AcumaticaTnT Support for OData and Apple version of MIcrosoft Excel - Looks like its coming

1

397

Mar 15, 21

Mar 15, 21

Questions You do not have access to this entity set.

Topic Tags: OData, site map, Generic Inquiry,

2

560

Sep 29, 20

Sep 29, 20

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'.

4

1,981

Feb 08, 20

Feb 08, 20

#AcumaticaTnT OData Refresh Only Updated Records

2

2,257

Dec 14, 19

Dec 14, 19

Questions ODBC Error in Power BI - Connection forcibly closed by remote host

8

11.6 K

Sep 16, 19

Sep 16, 19

#AcumaticaTnT Acumatica SaaS ODBC Access Retiring

4

1,313

Jul 31, 19

Jul 31, 19

#AcumaticaTnT Tips for working with OData in Acumatica

0

1,671

Mar 09, 19

Mar 09, 19

Questions Error for certain users when refreshing data in Excel

Topic Tags: Odata, Excel, GI,

6

4,455

Feb 22, 19

Feb 22, 19

Questions 8. Power BI – % of New Sales - Summit 2019 Session Examples

Topic Tags: acumatica user group,

1

1,791

Jan 29, 19

Jan 29, 19

Questions 7. Exporting to Excel vs. OData - Summit 2019 Session Examples

Topic Tags: acumatica user group,

0

3,290

Jan 28, 19

Jan 28, 19

Questions Get Count of Customer with Sales YoY

5

1,436

Nov 27, 18

Nov 27, 18

Questions Using JSON with OData in Acumatica

1

4,423

Nov 07, 18

Nov 07, 18

Questions As of 2018 R2 what is the value of Power BI over built in Acumatica reporting and data view tools?

1

1,375

Oct 29, 18

Oct 29, 18

Questions Error Setting up Power BI

1

1,488

Sep 20, 18

Sep 20, 18

Questions MAC and Odata

1

2,284

Sep 04, 18

Sep 04, 18

Questions Acumatica UTC datetime imported into MS SQL via OData

2

1,493

Aug 30, 18

Aug 30, 18

Questions OData queries and user sessions

1

2,130

Jun 26, 18

Jun 26, 18

Questions Enforce a formatting from Acumatica

5

1,872

Mar 19, 18

Mar 19, 18

Questions Security -- Power BI

1

1,469

Mar 01, 18

Mar 01, 18

Questions Deleting a Power BI App Registration in Azure

5

4,197

Feb 20, 18

Feb 20, 18

Questions update data to Acumatica from Excel

1

1,571

Feb 17, 18

Feb 17, 18

Questions Odata Fails... Sometimes

10

17.6 K

Jan 27, 18

Jan 27, 18

Questions Connecting to Acumatica OData from Microsoft Excel

3

6,394

Dec 27, 17

Dec 27, 17

Questions Null Attribute

2

2,720

Aug 05, 17

Aug 05, 17

Questions Adding Power BI Reports In Acumatica

14

4,478

Jul 12, 17

Jul 12, 17

Forum Statistics

11 Forums

2,118 Topics

9,449 Posts

9 Online

1,654 Members

Latest Post: Restricting access to sub accounts by segment value - group type A Our newest member: Cory Griffiths Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Acumatica Forums