Skip to main content

    Power BI

    Under Review

    Increase the data export row limit (30,000 rows max) in Power BI Report Server

    Vote (851) Share
    Ken Wetherell's profile image

    Ken Wetherell on 01 Feb 2018 03:41:30

    The capability to export raw data from Power BI is an important function for many users.

    Presently, the export data limits are as follows and confirmed at the community link below.

    - Power BI Service (cloud platform): 150,000 row maximum
    - Power BI Report Server (on-premise platform): 30,000 row maximum

    Please increase the export limit setting on Report Server to match that of Service. Better yet, increase them both to a much higher limit as requested by others in separate idea posts.

    http://community.powerbi.com/t5/Report-Server/What-is-the-Export-data-row-count-limit-for-Power-BI-Report/m-p/343951

    Administrator on 14 Dec 2019 08:13:11

    Thanks for your feedback - we are including the ability to Export to Excel from visuals with the Jan 2020 release, and this will up the export limit to the same levels as the PBI Service (150k rows).

    Comments (61)
    Ken Wetherell's profile image Profile Picture

    70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:23

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    We want this functionnality! Any update?

    Ken Wetherell's profile image Profile Picture

    70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:18

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    For power bi report server, you must add a variable configuration in order to limit the data row export to csv file : so, each organization can limit the export csv.

    Ken Wetherell's profile image Profile Picture

    70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:07

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    Increase the data export row limit

    Ken Wetherell's profile image Profile Picture

    70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:07

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    There is news for this limitation?

    Ken Wetherell's profile image Profile Picture

    7e2000e4 f1d0-4806-8598-81cef5e83434 on 05 Jul 2020 23:58:30

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    It would be helpful to increase this limit to a good higher number if possible

    Ken Wetherell's profile image Profile Picture

    d4c9337c 0770-4fbf-b277-d966a2e34593 on 05 Jul 2020 23:58:29

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    Any update?

    Ken Wetherell's profile image Profile Picture

    b8bcaf83 9b92-4154-83f6-0a9497a0d53c on 05 Jul 2020 23:56:50

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    Hello Chris, We had to change our data access methods and architecture because of this limitation. Any update on increasing the download limit?

    Ken Wetherell's profile image Profile Picture

    a4e95a07 3c79-45be-ba12-375494924183 on 05 Jul 2020 23:54:08

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    would also vote on this idea

    export limits must match the excel limits of 1000000 rows

    Ken Wetherell's profile image Profile Picture

    aaf815b9 2b3d-42d3-95dc-2d1595ec7b48 on 05 Jul 2020 23:53:28

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    Increase the data export row limit

    Ken Wetherell's profile image Profile Picture

    087bbd7f c788-4509-8099-db4103d28aab on 05 Jul 2020 23:50:19

    RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server

    Please work on this idea. Ad hoc requests require the raw data. Can't build a tab in reports for each request.