I am attempting to set up OData Feeds to an Excel Data Model that will be used for KPI Dashboards. I am creating the connections as “Connection Only” and Loading the data to the Data Model not as a table in the workbook.
The connections seem good and I have the initial data but when I refresh the connection I get the following errors. (See attached.) I am hoping someone can give me some detail as to what they mean.
Error when ODatat Feed URL (REST URL) is used in browser…
This XML file does not appear to have any style information associated with it. The document tree is shown below.
BadRequest
REST API Exception
BAQ execution failed with error: Bad SQL statement. Review the server event logs for details.
Ice.Common.BusinessObjectException
BAQ execution failed with error:
Error
Epicor.RESTApi.dll
ThrowExceptionOnBaqErrors
13
59
Bad SQL statement. Review the server event logs for details.
Error
Epicor.RESTApi.dll
ThrowExceptionOnBaqErrors
17
71
Error in Power Query…
DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request.
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request.
Details:
DataSourceKind=OData
DataSourcePath=https://gvlep01.teleco.com/epicorerp/api/v1/BaqSvc/TELKPISales