Different values when I export

[jak8282]

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 filters on the visual/page or report.

Any help appreciated.

Chris

[Anonymous]

Thanks for the reply from Bibiano_Geraldo, please allow me to provide another insight.
Hi @jak8282 ,

There are some limitations when exporting data from a visual that may cause the exported rows to not match what is expected.
Export data from a Power BI visualization - Power BI | Microsoft Learn
For export from matrix visuals using Data with current layout, the export limit is 150,000 data intersections. For a table visual, each row has one data intersection. For a matrix visual, each row can have 1 or more data intersections, so the exported rows count can be less than 150,000. (For example, if a matrix visual has three data intersections per row, the maximum row count is 150,000 / 3 = 50,000 rows.) The message "Exported data exceeded the allowed volume. Some data may have been omitted." is added at the footer of the Excel file when the limit is hit. To avoid this scenario, consider limiting the dimensions or filtering the data.

• When you're using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This result can happen if:

  • There are too many columns. Try reducing the number of columns and exporting again.

  • There's data that is difficult to compress.

  • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

• If the visualization uses data from more than one data table, and no active relationship exists for those tables in the data model, Power BI only exports data for the first table.

In your scenario, check if you encounter one of the limitations.

Below are similar issues where you can check the content.

Solved: EXPORTED DATA NOT MATCHING 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.

[jak8282]

@Anonymous Its a basic export ..

see file - https://www.dropbox.com/scl/fi/cp97heojryi3z8ewav8iw/report.pbix?rlkey=on2ecjbmsrgim2rmoyt5x5128&st=gnlc44l8&dl=0

Thanks

[Anonymous · Accepted solution]

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.

[jak8282]

Thanks @Anonymous  I'll give that a try

[Bibiano_Geraldo]

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

[jak8282]

Hi Bibiano @Bibiano_Geraldo 

See example file - gives a different count when I export

https://www.dropbox.com/scl/fi/cp97heojryi3z8ewav8iw/report.pbix?rlkey=on2ecjbmsrgim2rmoyt5x5128&st=...