Forum Discussion
Different values when I export
- Anonymous1 year ago
Hi jak8282 ,
This is expected behavior.
Duplicate rows are automatically deleted when fields are placed into the table visual, which results in not exporting all rows.
If you want to export all rows in this visual including duplicate rows, you can use the following DAX in a DAX query.EVALUATE SELECTCOLUMNS('Webchat', "Date",'Webchat'[Date], "Chat Requested",'Webchat'[Chat Requested], "First Engaged",'Webchat'[First Engaged], "Chat Released",'Webchat'[Chat Released], "Chat Concluded",'Webchat'[Chat Concluded], "Wrap-Up Time",'Webchat'[Wrap-Up Time], "Reference",'Webchat'[Reference #] )Or you can add an Index column (a column with a unique value) and then add it to the table visual to export all rows.
Please refer to the following link.Solved: Disable drop duplicates from table visual - Microsoft Fabric Community
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jak8282 ,
This is expected behavior.
Duplicate rows are automatically deleted when fields are placed into the table visual, which results in not exporting all rows.
If you want to export all rows in this visual including duplicate rows, you can use the following DAX in a DAX query.
EVALUATE
SELECTCOLUMNS('Webchat',
"Date",'Webchat'[Date],
"Chat Requested",'Webchat'[Chat Requested],
"First Engaged",'Webchat'[First Engaged],
"Chat Released",'Webchat'[Chat Released],
"Chat Concluded",'Webchat'[Chat Concluded],
"Wrap-Up Time",'Webchat'[Wrap-Up Time],
"Reference",'Webchat'[Reference #]
)
Or you can add an Index column (a column with a unique value) and then add it to the table visual to export all rows.
Please refer to the following link.
Solved: Disable drop duplicates from table visual - Microsoft Fabric Community
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Anonymous I'll give that a try