How can we improve Power BI?

← Power BI Ideas

Increase Export Data Limits

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.

1,152 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminAdam Wilson (POWER BI) (Product Manager, Microsoft Power BI) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

132 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Rick Jordan commented  ·   ·  Flag as inappropriate

    Power BI Service needs to increase the limit for # of rows to export to .csv and .xslx.
    This is in high demand by our business users in order to keep business momentum moving forward.

  • mark ginnebaugh commented  ·   ·  Flag as inappropriate

    This seems like a very simple issue to resolve. I know there are many other priorities, but the workarounds for this limit take far more effort than I think an actual fix would take. Is there a specific timeline for resolution? Thanks!

  • SueS commented  ·   ·  Flag as inappropriate

    Power BI Service needs to increase the limit for # of rows to export to .csv and .xslx.
    Raise it to the limits Excel allows in a workbook.

  • rodman commented  ·   ·  Flag as inappropriate

    We are using Power BI Report server, and the limit is still 30000 rows. Power BI will not be an enterprise solution in our environment if this cannot be increased.

  • Sireesha commented  ·   ·  Flag as inappropriate

    It's a common ask from users to be able to download large number of rows and columns for different purposes - for compliance, to share with external customers etc. The limitations of data export has been a major issue for user adoption in our organization. Please also support reliable export from SSAS live connections.

  • stefano commented  ·   ·  Flag as inappropriate

    We would like using PowerBi Pro for Azure chargeback reporting. We have reporting in place using tags but this limitation is very annoying. Usage details report from EA portal have about 300000 row per month.

  • Earle Lindfors commented  ·   ·  Flag as inappropriate

    Very difficult to advocate for this product to support the "Enterprise" with this kind of limitation on export. With migrations to Windows 10 builds 1709 and 1803 of interest to DOD, this capability is perfect for tracking progress. However, when looking to take action on the results (which will certainly exceed 30K records) during the initial phases, it renders the capability short of supporting Enterprise requirements. PLEASE put your best engineers on this issue ASAP. Power BI is too powerful and valuable not to.

  • Matthew Kiley commented  ·   ·  Flag as inappropriate

    We are using Power BI Report server, and the limit is still 30k. Power BI will not be an enterprise solution in our environment if this cannot be increased.

  • M commented  ·   ·  Flag as inappropriate

    This was planned a year ago. Any idea when this will be released?

  • Kurt Barajas commented  ·   ·  Flag as inappropriate

    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.

  • Ramy commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • Lee Haakenson commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

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

← Previous 1 3 4 5 6 7

Power BI Ideas: Dashboard

Categories

Feedback and Knowledge Base

(thinking…)

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.