Skip to main content

    Power BI

    Needs Votes

    Increase Export Data Limits

    Vote (1482) Share
    Adam Wilson (POWER BI)'s profile image

    Adam Wilson (POWER BI) on 24 Feb 2017 01:34:44

    In late 2016, Power BI improved our export data options to allow exporting up to 150,000 rows to Excel from a visual on a Power BI dashboard for Pro users. If you require higher limits, please vote on this idea. If you have more specific requirements, please leave them in the comments.

    Administrator on 30 Jul 2020 16:56:47

    There are longer term plans to allow larger exports in that use case, but there isn't a current timeline as to when that will be available. Customers who have Power BI Premium can set a drill-through to paginated reports via URL parameters as a workaround in the interim, as there is no data export limit for paginated reports.

    Comments (158)
    Adam Wilson (POWER BI)'s profile image Profile Picture

    32a6d138 b1bd-4827-b016-3ae240d42694 on 05 Jul 2020 23:13:37

    RE: Increase Export Data Limits

    PBI team any update on this. Can we expect in this near future

    Adam Wilson (POWER BI)'s profile image Profile Picture

    bfa042f7 d994-4a4e-a1b7-8dd2e49fcbd4 on 05 Jul 2020 23:13:06

    RE: Increase Export Data Limits

    Why limit the export at all? Since we are merely dumping the table into a csv file, I can see no reason why the entire table (of any size) cannot be dumped to the csv. We often use PBI Desktop to mashup the data, then need to post-process it in some other software. Is there any legitimate reason why MS needs to limit the number of rows? If PBI can create a table with millions of rows, we certainly should be able to dump the full table to a csv.

    Adam Wilson (POWER BI)'s profile image Profile Picture

    cd951c64 2a96-4d9a-9eda-92954ef944f0 on 05 Jul 2020 23:12:43

    RE: Increase Export Data Limits

    I agree with other comments - this should be unlimited if at all possible, for live/direct query as well as other types of connection.

    Adam Wilson (POWER BI)'s profile image Profile Picture

    9cdd00f5 ecf5-4e60-bc0b-8811ada2fd1e on 05 Jul 2020 23:12:26

    RE: Increase Export Data Limits

    does it export 150,000 rows when using Direct Query? I'm trying to export around 40K rows but it only exports 20K+ rows and each time i export i get a different number.

    Adam Wilson (POWER BI)'s profile image Profile Picture

    e844cbd0 6974-ea11-a811-000d3a579c38 on 05 Jul 2020 23:11:25

    RE: Increase Export Data Limits

    I need to export more rows. There should not be a limit!

    Adam Wilson (POWER BI)'s profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:11:10

    RE: Increase Export Data Limits

    Why limits? I don't understand it.

    Adam Wilson (POWER BI)'s profile image Profile Picture

    4d9fd9ad 0003-4349-834a-f2e565de872e on 05 Jul 2020 23:11:08

    RE: Increase Export Data Limits

    no limits

    Adam Wilson (POWER BI)'s profile image Profile Picture

    2299a643 c7c8-425f-9aea-7644a62a7e75 on 05 Jul 2020 23:11:03

    RE: Increase Export Data Limits

    Yes

    Adam Wilson (POWER BI)'s profile image Profile Picture

    8510aecd a2ec-425f-8fbc-f586995bbe5b on 05 Jul 2020 23:10:58

    RE: Increase Export Data Limits

    Enable the summarized report to be exported to Excel.

    Adam Wilson (POWER BI)'s profile image Profile Picture

    c239e485 8e3a-48d1-8d32-18283b494031 on 05 Jul 2020 23:10:57

    RE: Increase Export Data Limits

    I was really disappointed to discover this 30K row limit. Spending a day playing with Power BI Desktop I was starting to think it might be a useful tool. I wanted to use it to manipulate large datasets. But this limitation is a showstopper and there can not really be a valid technical reason for it!