Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |