Forum Discussion
SQL Management Studio output is not the same with Power BI Visual Table.
I have a query that runs like this: SELECT H.TKT_DAT,
L.ITEM_NO
FROM VI_PS_DOC_HDR H JOIN VI_PS_DOC_LIN L ON H.DOC_ID = L.DOC_ID
JOIN PO_VEND P ON L.ITEM_VEND_NO = P.VEND_NO
WHERE H.TKT_T...
Hi jhonKy0t ,
I'm guessing you have Include relationship columns checked, and it will return all the associated data.
Please uncheck the box to try.
Please feel free to correct me and provide more information if I have misunderstood you!
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.