Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error

Question

Hi.The full error message is:Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Incorrect syntax near the keyword 'union'.. '.&nbsp;Trying to append two queries. See all queries below.&nbsp;Append – Warranty ratios (BIDW)let&nbsp;&nbsp;&nbsp; Source = Table.Combine({#"Installed base - Power and TiLite (BIDW)", #"Warranty ratios (BIDW)"})in&nbsp;&nbsp;&nbsp; Source&nbsp;Installed base – Power and TiLite (BIDW)let&nbsp;&nbsp;&nbsp; Source = Sql.Databases("SERVER"),&nbsp;&nbsp;&nbsp; DATABASE = Source{[Name="DATABASE"]}[Data],&nbsp;&nbsp;&nbsp; DW_V_InvoiceDetailsUNION = DATABASE{[Schema="DW",Item="V_InvoiceDetailsUNION"]}[Data],&nbsp;&nbsp;&nbsp; #"Removed Other Columns" = Table.SelectColumns(DW_V_InvoiceDetailsUNION,{"WKInvoiceDate", "WKCustomer", "WKProduct", "IsChair", "SerialNumber"}),&nbsp;&nbsp;&nbsp; #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([SerialNumber] &lt;&gt; null and [SerialNumber] &lt;&gt; "" and [SerialNumber] &lt;&gt; "NA") and ([IsChair] = 1)),&nbsp;&nbsp;&nbsp; #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"WKInvoiceDate", Order.Ascending}})in&nbsp;&nbsp;&nbsp; #"Sorted Rows"&nbsp;&nbsp;Warranty ratios (BIDW)let&nbsp;&nbsp;&nbsp; Source = Sql.Databases("SERVER"),&nbsp; &nbsp; DATABASE = Source{[Name="DATABASE"]}[Data],&nbsp;&nbsp;&nbsp; DW_V_InvoiceDetailsUNION = DATABASE{[Schema="DW",Item="V_InvoiceDetailsUNION"]}[Data],&nbsp;&nbsp;&nbsp; #"Removed Other Columns" = Table.SelectColumns(DW_V_InvoiceDetailsUNION,{"WKInvoiceDate", "WKCompany", "WKCustomer", "WKProduct", "WKOrderCategory", "SerialNumber", "NetAmount", "CostAmount", "OrderQuantity"}),&nbsp;&nbsp;&nbsp; #"Filtered Rows1" = Table.SelectRows(#"Removed Other Columns", each ([SerialNumber] &lt;&gt; null and [SerialNumber] &lt;&gt; "" and [SerialNumber] &lt;&gt; "NA") and ([WKOrderCategory] = 6)),&nbsp;&nbsp;&nbsp; #"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each [WKInvoiceDate] &gt;= #date(2015, 1, 1))in&nbsp;&nbsp;&nbsp; #"Filtered Rows2"&nbsp;

konradjonsson · Accepted Answer

Hi.Thanks. I found another solution, in another topic. I removed the sorting from one of the underlying queries -then the problem disappeared.

Forum Discussion

Related content

Fetch the File modification time

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error

Failed to save modifications to the server. Error returned: - Solution required

DataSource.Error List.Accumulate

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error