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 PowerBI: XML to see all GIS works great. But in PowerBI, credentials fail.

3

80

Jun 24

Jun 24

Questions Issue while connecting Acumatica from powerbi

2

395

Jun 24

Jun 24

Questions Excel Odata - Underlying Connection was closed.

Topic Tags: Excel, OData,

4

918

Jun 18

Jun 18

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

1

96

Jun 14

Jun 14

#AcumaticaTnT Applying Filters in OData

9

5,502

Jun 11

Jun 11

#AcumaticaTnT Acumatica and Excel OData Credentials on Local Computer

1

75

Jun 11

Jun 11

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

5

203

Apr 12

Apr 12

Questions Embedding Power BI Reports in Acumatica - Reply Address Error

23

17.3 K

Mar 15

Mar 15

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

1

117

Mar 15

Mar 15

Questions Odata Feed in 2020 R1

2

277

Jan 25

Jan 25

Questions You do not have access to this entity set.

Topic Tags: OData, site map, Generic Inquiry,

2

260

Sep 29

Sep 29

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,115

Feb 08, 20

Feb 08, 20

#AcumaticaTnT OData Refresh Only Updated Records

2

1,312

Dec 14, 19

Dec 14, 19

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

8

8,113

Sep 16, 19

Sep 16, 19

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

3

1,693

Aug 13, 19

Aug 13, 19

#AcumaticaTnT Acumatica SaaS ODBC Access Retiring

4

1,051

Jul 31, 19

Jul 31, 19

Questions OData Request Failed - Error 500

2

1,166

May 07, 19

May 07, 19

Questions A New Way to Embed Power BI Reports in Acumatica

Topic Tags: acumatica user group,

5

2,934

Apr 08, 19

Apr 08, 19

#AcumaticaTnT Tips for working with OData in Acumatica

0

1,297

Mar 09, 19

Mar 09, 19

Questions Error for certain users when refreshing data in Excel

Topic Tags: Odata, Excel, GI,

6

3,055

Feb 22, 19

Feb 22, 19

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

Topic Tags: acumatica user group,

1

1,424

Jan 29, 19

Jan 29, 19

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

Topic Tags: acumatica user group,

0

2,446

Jan 28, 19

Jan 28, 19

Questions Get Count of Customer with Sales YoY

5

998

Nov 27, 18

Nov 27, 18

Questions Using JSON with OData in Acumatica

1

3,312

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,161

Oct 29, 18

Oct 29, 18

Questions Error Setting up Power BI

1

1,193

Sep 20, 18

Sep 20, 18

Questions Creating a live dashboard on PowerBI or Excel Online

3

1,131

Sep 07, 18

Sep 07, 18

Questions MAC and Odata

1

1,951

Sep 04, 18

Sep 04, 18

Questions Acumatica UTC datetime imported into MS SQL via OData

2

1,240

Aug 30, 18

Aug 30, 18

Questions OData queries and user sessions

1

1,611

Jun 26, 18

Jun 26, 18

Questions Enforce a formatting from Acumatica

5

1,634

Mar 19, 18

Mar 19, 18

Questions Security -- Power BI

1

1,264

Mar 01, 18

Mar 01, 18

Questions Deleting a Power BI App Registration in Azure

5

3,688

Feb 20, 18

Feb 20, 18

Questions update data to Acumatica from Excel

1

1,333

Feb 17, 18

Feb 17, 18

Questions Odata Fails... Sometimes

10

16.1 K

Jan 27, 18

Jan 27, 18

Questions Connecting to Acumatica OData from Microsoft Excel

3

5,115

Dec 27, 17

Dec 27, 17

Questions Null Attribute

2

2,352

Aug 05, 17

Aug 05, 17

Questions Adding Power BI Reports In Acumatica

14

3,648

Jul 12, 17

Jul 12, 17

Forum Statistics

11 Forums

1,878 Topics

8,534 Posts

4 Online

1,339 Members

Latest Post: Adding "selected" criteria to a report? Our newest member: Chrissy Pakutka 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