Direct Query Sql server (incorrect syntax near ')' idb command interface in power bi)

[Vinothsusai]

Hello,

I have used the direct query sql server for the visuals but it displays the error incorrect syntax near ')' idb command interface in power bi.(data imported successfully but when i use field in the visuals, throws the below error)

SQL query

SELECT DRTT.TRANSACTIONID, DRTT.TRANSDATE,DRTT.CUSTACCOUNT,DRTT.TYPE,DRTT.AUTSALESORDERID AS SALESORDERID,DRTT.AUTRECEIPTID AS RECIEPTID, '' AS STORE, DRTT.AUTLOYALTYCARDID AS LOYALTYCARDID, DRTT.AUTRECEIPTEMAIL,'' AS DLVMODE, DRTT.TERMINAL AS TERMINAL,'' AS STORENAME FROM DMFRetailTransactionTableEntity DRTT
JOIN DMFAUTCustInvoiceTransEntity DACIT ON DACIT.SALESID = DRTT.AUTSALESORDERID

WHERE DRTT.type = 'Commande client' AND DACIT.INVOICEDATE = DRTT.TRANSDATE
AND DRTT.AUTRECEIPTID <> ''
UNION
SELECT DRTS.TRANSACTIONID ,DRTS.TRANSDATE,DRTS.CUSTACCOUNT,DRTS.TYPE,'' AS SALESORDERID,DRTS.RECEIPTID,DRTS.STORE,DRTT.AUTLOYALTYCARDID AS LOYALTYCARDID,'' AS RECEIPTMAIL, DRTS.DLVMODE, DRTS.TERMINALID AS TERMINAL ,'' AS STORENAME FROM DMFRetailTransSalesViewEntity DRTS
LEFT JOIN DMFRetailTransactionTableEntity DRTT ON DRTS.RECEIPTID = DRTT.AUTRECEIPTID

WHERE DRTS.AUTSOPROCESSTYPE = 'Commande standard' AND
DRTS.DLVMODE = '' AND
DRTS.RECEIPTID <> '' 

Please advise.

Thanks

Vinoth

[lbendlin]

That doesn't look like a query generated by Power BI. Is that your original source query?

Can you capture the query that is generated by the visual, using Fiddler or the Performance analyzer?