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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Export Data Issues

Hi all,

 

I have published a report, and when exporting the table only half of the rows are exporting.

 

There are only 3000 rows so I shouldn't be hitting any limitations.

 

There are also relationships between the data sources that used to construct the table.

 

Please let me know what I can do to resolve this.

 

 

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

Would you please check the following limitations:

 

Export using Underlying data will not work if the data source is an Analysis Services live connection  

 

When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Petebro
Employee
Employee

This is odd behavior for sure. It will likely take more interation and back and forth with specifics about your datasource. I think the best course of action would be to engage customer support so they can look at your private information securely. 

Anonymous
Not applicable

Yep the count is 1500, the values in the powerBI visual are definetly different to what's being exported

FarhanAhmed
Community Champion
Community Champion

are you getting 1500 rows out of 3000 only?

can you please check the count in the table in Power BI?







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors