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

    0b8a2565 d1cb-e811-a96b-000d3a1bece3 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

    80d22464 462d-49e0-8be5-6334e01a3ba6 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

    b507bbe7 fa35-4584-8928-5a4065b96594 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

    4c3d4637 53b5-447b-92f9-e7ec0e92995d 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

    74885d91 8279-4f4d-9b56-4d96eff86370 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    b9363c27 1a31-433a-a2f4-2f14bc9ed632 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

    7b4b15ef 87bd-44dc-b85e-8f5fd48eba96 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

    8cb36c3a 8cbf-4696-b616-012b8630b595 on 05 Jul 2020 23:07:03

    RE: Increase Export Data Limits

    Please get this sorted asap.