SupportCategory: Simple Object DesignerError when connecting to web service API
Matt Deuser asked 4 months ago
I am getting this error in Power BI when trying to connect to web service APIs  I created using Simple Object Creator. sales_Invoice_Lines Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The current operation was cancelled because another operation in the transaction failed. '.
hougaard Staff replied 4 months ago

What table number is this?

1 Answers
Matt Deuser answered 4 months ago
Tables 112 and 113. Posted Sales Headers and Invoices.
hougaard Staff replied 4 months ago

Those are protected tables, you cannot write to them. What are trying to do?

Matt Deuser replied 4 months ago

I am trying to access them from Power Bi to use for reports