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

    Power BI User on 05 Jul 2020 23:48:59

    RE: Increase Export Data Limits

    Agree to have max row limit of excel.

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

    Kurt Barajas on 05 Jul 2020 23:48:47

    RE: Increase Export Data Limits

    My company recently began using Power BI and the row limit continues to be a severe limitation. The data from visualizations and tables needs to exported for validation and to be sent to other parties.

    I find myself taking many small chunks of data but as soon as we change part of our model, we have to go through the tedious task of re-exporting. Every single time.

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

    Rolen Lo on 05 Jul 2020 23:48:14

    RE: Increase Export Data Limits

    How long do we need to wait further?

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

    Power BI Ideas Admin on 05 Jul 2020 23:48:10

    RE: Increase Export Data Limits

    People will start losing confidence in this tool since raw data is limited to 150K and they cannot validate or do analysis properly.

    Please can you increase the limit to match excel.

    Thanks

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

    Liam Newlin on 05 Jul 2020 23:47:37

    RE: Increase Export Data Limits

    Are there any updates related to removing the export limitation in Power BI Reporting Services? Will this be in the May, 2019 PBIRS Release?

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

    Lee Haakenson on 05 Jul 2020 23:46:46

    RE: Increase Export Data Limits

    Definitely need to remove this limitation. We are evaluating multiple options, and this would definitely be a deal breaker for my organization.

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

    Power BI User on 05 Jul 2020 23:46:38

    RE: Increase Export Data Limits

    definitely need no limit. drill downs are basically unusable unless you set a filter and then tie the data back together after exporting.

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

    Power BI User on 05 Jul 2020 23:46:19

    RE: Increase Export Data Limits

    '+1 for increasing or removing the limit for Power BI Report Server.

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

    Power BI User on 05 Jul 2020 23:44:50

    RE: Increase Export Data Limits

    It's been a year and admin promise to increase a year ago but nothing. meh.

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

    Rafael Borghi on 05 Jul 2020 23:44:38

    RE: Increase Export Data Limits

    Also, it should allow to increase the export limit for Power BI Report Server (and not only to Power BI Service)