Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
manalla
Helper V
Helper V

Data export issue from Table Visual in Power BI Desktop

Hi,

 

I have simple tabular report with 2185 rows. Visual clearly shows it has 2185 rows, when i add ID column with count.

When i export it from PBI desktop - it exports only 1469 rows (including header). I see the same behaviour when deployed to report server.

 

One of my other user reported that her export from desktop is only exporting around 857 records (including header).

 

Why is this happening? any known bug with the tool or so?

We are using Version: 2.69.5467.1801 64-bit (May 2019) of desktop.

 

Please suggest.

 

Thansk

Manoj

1 REPLY 1
v-gizhi-msft
Community Support
Community Support

Hi,

 

I think it is related to exporting limitations:

20.PNG

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and... 

 

You can also try to export data by DAX Studio to compare the result with that from Power BI Desktop.

 

Best Regards,

Giotto Zhi

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.