Download all data from report

[swong]

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.

[v-jiascu-msft · Accepted solution]

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