Forum Discussion

jak8282's avatar
jak8282
Helper III
1 year ago
Solved

Different values when I export

Hi,   I have a basic table with no filters and there are 349 rows of data - when I do a count on the date field.   However when I export from PBI desktop I am only getting 343 rows?   No filter...
  • Anonymous's avatar
    Anonymous
    1 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.