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...

Need Help

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.

Bibiano_Geraldo

Super User

1 year ago

Hi jak8282 ,

Its complicated to answer this due we are'nt see the data, if possible, you can share not sensitive file to understand well what is happening in your data:

This can occour by the many reasons:

Data Aggregation: Power BI might be aggregating some data, which can result in fewer rows being exported. Ensure that your table visualization is set to show all items, including those with no data.

Duplicates and Data Transformations: Check for any duplicate data or transformations that might be affecting the row count.

And so on.

Thank you