cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Download all data from report

Hi,

 

I'm trying to export data from a graph, but my data is too large, causing data sampling to occur.

 

What is the limit on data size? Is there a specific way the data is being sampled?

 

I have a line graph that contained Account Id, and is sliceable in a few different ways. I'm hoping to use the slicers, and then export the list of distinct Account Ids it applies to.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Hi @swong,

 

Please reference this documentation: powerbi-service-export-data.

>>>

The maximum number of rows that can be exported to .csv is 30,000.

The maximum number of rows that can be exported to .xlsx is 150,000.

 

 

You could filter the data first, then export one by one if the data is smaller than the maximum after filtering.

 

Best Regards!

Dale

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

View solution in original post

1 REPLY 1
Microsoft
Microsoft

Hi @swong,

 

Please reference this documentation: powerbi-service-export-data.

>>>

The maximum number of rows that can be exported to .csv is 30,000.

The maximum number of rows that can be exported to .xlsx is 150,000.

 

 

You could filter the data first, then export one by one if the data is smaller than the maximum after filtering.

 

Best Regards!

Dale

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors