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

    Richard Plumtree on 05 Jul 2020 23:07:03

    RE: Increase Export Data Limits

    150,000 rows is a rediculously low limit for big data, needs to be aligned to Excel level limits.

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

    Jairo Ibáñez Navarro on 05 Jul 2020 23:06:54

    RE: Increase Export Data Limits

    Please remove limits on exporting data. My vote is YES.

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

    Paulo Rigazzo on 05 Jul 2020 23:06:40

    RE: Increase Export Data Limits

    Please remove export data limits!

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

    Power BI User on 05 Jul 2020 23:06:25

    RE: Increase Export Data Limits

    I vote yes :)

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

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

    RE: Increase Export Data Limits

    suggest change the subject to "remove export data limit" instead of just increase.

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

    Power BI User on 05 Jul 2020 23:04:26

    RE: Increase Export Data Limits

    Lets make Power BI proper Reporting tool. Every reporting tool must be offering capability of exporting millions of rows to Excel. Otherwise tools sucks :D.

    Now seriously, there should be limit around 1-3M cells to be exported. This is what we have available in SAP reporting tools.

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

    Q on 05 Jul 2020 23:03:33

    RE: Increase Export Data Limits

    Data export row limitations should be removed with the option of configuring the limitations available for developers (for load planning purposes).

    With the release of Power BI Report Server, on-premise users who view web versions of the reports are limited to 30k rows of data to export.

    Power BI reports are often used as an interface by business users to obtain data as if they are running SQL queries. If there is no way to export the data out of Power BI if the result set is more than 30k, the data is basically stuck in the Power BI interface and not useable in other workflows.

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

    Vinod KV on 05 Jul 2020 23:03:12

    RE: Increase Export Data Limits

    Pls remove the export line limit to export in Excel

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

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

    RE: Increase Export Data Limits

    Maximum limit to export should match the max limit of Excel. If it fits in Excel is should be able to be exported, If it doesn't fit in your Excel then it is too much to export.

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

    Ralf on 05 Jul 2020 23:01:55

    RE: Increase Export Data Limits

    The export limit to 30k rows (or even 150k for Pro) disqualifies Power BI as a reporting tool. It will definitly not be introduced in our company.