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 Creating a live dashboard on PowerBI or Excel Online

10

1,232

Oct 19

Oct 19

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

3

212

Jun 24

Jun 24

Questions Issue while connecting Acumatica from powerbi

2

456

Jun 24

Jun 24

Questions Excel Odata - Underlying Connection was closed.

Topic Tags: Excel, OData,

4

1,020

Jun 18

Jun 18

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

1

268

Jun 14

Jun 14

#AcumaticaTnT Applying Filters in OData

9

5,817

Jun 11

Jun 11

#AcumaticaTnT Acumatica and Excel OData Credentials on Local Computer

1

255

Jun 11

Jun 11

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

5

345

Apr 12

Apr 12

Questions Embedding Power BI Reports in Acumatica - Reply Address Error

23

17.7 K

Mar 15

Mar 15

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

1

172

Mar 15

Mar 15

Questions Odata Feed in 2020 R1

2

364

Jan 25

Jan 25

Questions You do not have access to this entity set.

Topic Tags: OData, site map, Generic Inquiry,

2

331

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

Feb 08, 20

Feb 08, 20

#AcumaticaTnT OData Refresh Only Updated Records

2

1,553

Dec 14, 19

Dec 14, 19

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

8

9,153

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

Aug 13, 19

Aug 13, 19

#AcumaticaTnT Acumatica SaaS ODBC Access Retiring

4

1,121

Jul 31, 19

Jul 31, 19

Questions OData Request Failed - Error 500

2

1,363

May 07, 19

May 07, 19

Questions A New Way to Embed Power BI Reports in Acumatica

Topic Tags: acumatica user group,

5

3,294

Apr 08, 19

Apr 08, 19

#AcumaticaTnT Tips for working with OData in Acumatica

0

1,410

Mar 09, 19

Mar 09, 19

Questions Error for certain users when refreshing data in Excel

Topic Tags: Odata, Excel, GI,

6

3,433

Feb 22, 19

Feb 22, 19

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

Topic Tags: acumatica user group,

1

1,512

Jan 29, 19

Jan 29, 19

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

Topic Tags: acumatica user group,

0

2,645

Jan 28, 19

Jan 28, 19

Questions Get Count of Customer with Sales YoY

5

1,112

Nov 27, 18

Nov 27, 18

Questions Using JSON with OData in Acumatica

1

3,584

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

Oct 29, 18

Oct 29, 18

Questions Error Setting up Power BI

1

1,260

Sep 20, 18

Sep 20, 18

Questions MAC and Odata

1

2,045

Sep 04, 18

Sep 04, 18

Questions Acumatica UTC datetime imported into MS SQL via OData

2

1,305

Aug 30, 18

Aug 30, 18

Questions OData queries and user sessions

1

1,753

Jun 26, 18

Jun 26, 18

Questions Enforce a formatting from Acumatica

5

1,701

Mar 19, 18

Mar 19, 18

Questions Security -- Power BI

1

1,311

Mar 01, 18

Mar 01, 18

Questions Deleting a Power BI App Registration in Azure

5

3,839

Feb 20, 18

Feb 20, 18

Questions update data to Acumatica from Excel

1

1,398

Feb 17, 18

Feb 17, 18

Questions Odata Fails... Sometimes

10

16.4 K

Jan 27, 18

Jan 27, 18

Questions Connecting to Acumatica OData from Microsoft Excel

3

5,424

Dec 27, 17

Dec 27, 17

Questions Null Attribute

2

2,427

Aug 05, 17

Aug 05, 17

Questions Adding Power BI Reports In Acumatica

14

3,814

Jul 12, 17

Jul 12, 17

Forum Statistics

11 Forums

1,942 Topics

8,754 Posts

5 Online

1,422 Members

Latest Post: Percentage in KPI Widget from GI Our newest member: Myles Carroll 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