Forum Discussion

swong's avatar
swong
Helper II
9 years ago
Solved

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.

  • 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

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    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