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 Can you authenticate with Active Directory user

3

153

Oct 27

Oct 27

Questions OData Request Failed - Error 500

3

2,199

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

Mar 17

Mar 17

#AcumaticaTnT Making OData Faster

4

539

Mar 16

Mar 16

Questions Odata Feed in 2020 R1

3

725

Feb 23

Feb 23

Questions A New Way to Embed Power BI Reports in Acumatica (1 viewing)

Topic Tags: acumatica user group,

11

5,043

Nov 15, 21

Nov 15, 21

Questions Creating a live dashboard on PowerBI or Excel Online

10

1,769

Oct 19, 21

Oct 19, 21

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

3

825

Jun 24, 21

Jun 24, 21

Questions Issue while connecting Acumatica from powerbi

2

659

Jun 24, 21

Jun 24, 21

Questions Excel Odata - Underlying Connection was closed.

Topic Tags: Excel, OData,

4

1,444

Jun 18, 21

Jun 18, 21

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

1

1,040

Jun 14, 21

Jun 14, 21

#AcumaticaTnT Applying Filters in OData

9

7,543

Jun 11, 21

Jun 11, 21

#AcumaticaTnT Acumatica and Excel OData Credentials on Local Computer

1

977

Jun 11, 21

Jun 11, 21

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

5

928

Apr 12, 21

Apr 12, 21

Questions Embedding Power BI Reports in Acumatica - Reply Address Error

23

20.3 K

Mar 15, 21

Mar 15, 21

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

1

607

Mar 15, 21

Mar 15, 21

Questions You do not have access to this entity set.

Topic Tags: OData, site map, Generic Inquiry,

2

915

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

2,457

Feb 08, 20

Feb 08, 20

#AcumaticaTnT OData Refresh Only Updated Records

2

2,630

Dec 14, 19

Dec 14, 19

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

8

12.9 K

Sep 16, 19

Sep 16, 19

#AcumaticaTnT Acumatica SaaS ODBC Access Retiring

4

1,470

Jul 31, 19

Jul 31, 19

#AcumaticaTnT Tips for working with OData in Acumatica

0

1,833

Mar 09, 19

Mar 09, 19

Questions Error for certain users when refreshing data in Excel

Topic Tags: Odata, Excel, GI,

6

5,100

Feb 22, 19

Feb 22, 19

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

Topic Tags: acumatica user group,

1

1,960

Jan 29, 19

Jan 29, 19

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

Topic Tags: acumatica user group,

0

3,828

Jan 28, 19

Jan 28, 19

Questions Get Count of Customer with Sales YoY

5

1,594

Nov 27, 18

Nov 27, 18

Questions Using JSON with OData in Acumatica

1

5,018

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

Oct 29, 18

Oct 29, 18

Questions Error Setting up Power BI

1

1,634

Sep 20, 18

Sep 20, 18

Questions MAC and Odata

1

2,454

Sep 04, 18

Sep 04, 18

Questions Acumatica UTC datetime imported into MS SQL via OData

2

1,626

Aug 30, 18

Aug 30, 18

Questions OData queries and user sessions

1

2,386

Jun 26, 18

Jun 26, 18

Questions Enforce a formatting from Acumatica

5

2,014

Mar 19, 18

Mar 19, 18

Questions Security -- Power BI

1

1,605

Mar 01, 18

Mar 01, 18

Questions Deleting a Power BI App Registration in Azure

5

4,406

Feb 20, 18

Feb 20, 18

Questions update data to Acumatica from Excel

1

1,707

Feb 17, 18

Feb 17, 18

Questions Odata Fails... Sometimes

10

19.9 K

Jan 27, 18

Jan 27, 18

Questions Connecting to Acumatica OData from Microsoft Excel

3

7,176

Dec 27, 17

Dec 27, 17

Questions Null Attribute

2

2,908

Aug 05, 17

Aug 05, 17

Questions Adding Power BI Reports In Acumatica

14

4,817

Jul 12, 17

Jul 12, 17

Forum Statistics

11 Forums

2,215 Topics

9,762 Posts

14 Online

1,770 Members

Latest Post: Variable from Footer included in running total Our newest member: Ronel Liebenberg 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