Skip to main content

    Power BI

    Completed

    Increase Export Data Limits

    Vote (1854) 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 01 Feb 2023 00:01:36

    WWe ha a new feature that provides an increased limit of 500K rows of data to Excel from a Power BI visual. Learn more...Announcing Connected Excel Tables from Power BI (Public Preview) | Microsoft Power BI Blog | Microsoft Power BI

    - Ikechukwu

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

    Diana Resendez on 05 Jul 2020 23:08:24

    RE: Increase Export Data Limits

    Need ability to export more rows of data. This is a basic need of many of our users and if a limitation like this exists, they will move to another tool.

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

    Tom Stachura on 05 Jul 2020 23:08:12

    RE: Increase Export Data Limits

    I am hitting the limit with about 1700 records!

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

    marnix jansen on 05 Jul 2020 23:08:11

    RE: Increase Export Data Limits

    Really need to export more then 150,000 rows because we need to be able to share outcome of analysis with people that do not use PowerBI. Major issue.

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

    Colin Oglesbee on 05 Jul 2020 23:08:07

    RE: Increase Export Data Limits

    Please remove this limitation, in alignment with SSRS. My managers depend on the export capability to focus on quality improvement, and need to be able to export a very large number of rows.

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

    Martin Hester on 05 Jul 2020 23:07:51

    RE: Increase Export Data Limits

    Please remove data export limitation. 150K lines is nothing. Or allow a .csv file, or something. Exporting 5 different files and then joining them up in my case is tiresome.

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

    Power BI Ideas Admin on 05 Jul 2020 23:07:43

    RE: Increase Export Data Limits

    At the bare minimum let the PowerBI Admin role assign the limit online. Otherwise definitely remove the limit from PBI Desktop.

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

    Power BI Ideas Admin on 05 Jul 2020 23:07:43

    RE: Increase Export Data Limits

    Please eliminate export limits!

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

    Aoife on 05 Jul 2020 23:07:42

    RE: Increase Export Data Limits

    Finding it incredibly frustrating to constantly receive the "Your data is too large" error when trying to export. This really needs to be fixed, I cannot understand why Power BI desktop is unable to handle a simple export request.

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

    Power BI User on 05 Jul 2020 23:07:05

    RE: Increase Export Data Limits

    It would be great if you can remove limits on exporting data.

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

    Nimish Bhatnagar on 05 Jul 2020 23:07:03

    RE: Increase Export Data Limits

    Please get this sorted asap.