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

    ace9628a b63e-4f3e-a555-73bfd1f0a5e0 on 05 Jul 2020 23:13:00

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

    Users are interested in the reports to be downloaded in excel, please add this functionality in power bi report server.