How can we improve Power BI?

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.

523 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    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 →

    56 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Elizabeth Tachjian commented  ·   ·  Flag as inappropriate

        The visual dashboard receiver sometimes need to answer their own questions and at times this can only be done by reviewing the raw data using the export to excel function to answer those questions at real-time. Asking the report user to go the developer is moving away from being a self service platform. Microsoft are you providing a service based on your vision or not.

      • Caroline commented  ·   ·  Flag as inappropriate

        On Power BI Desktop we can export only 15.000 lines. On Power BI Web we can export 150.000 lines. Why such a difference ! A pain to publish and switch each time to export data (and I don't want to work on Power BI Web).

      • Anonymous commented  ·   ·  Flag as inappropriate

        The excel number of rows would be a great limit so we can export more than 500K rows

      • Nio commented  ·   ·  Flag as inappropriate

        Our business users intend to migrate the excel based reports to Power BI.
        The export limits must be comparable and align with Excel. The 30K export limitation is a potential showstopper since it limits users ability to dig into "related" details of the summarized data.
        This basic obstacle needs to be addressed.

      • Taha commented  ·   ·  Flag as inappropriate

        I agree, I can only export 15,000 records. And there's a bug that gives you the "data exceeds the limit" error message even if ur way under the 15k limit. But at least, it dumps out upto 15k records, so you just have to ignore the error message.

      • Diana R commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Colin Oglesbee commented  ·   ·  Flag as inappropriate

        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.

      • Martin Hester commented  ·   ·  Flag as inappropriate

        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.

      • David McCoy commented  ·   ·  Flag as inappropriate

        At the bare minimum let the PowerBI Admin role assign the limit online. Otherwise definitely remove the limit from PBI Desktop.

      • Scott Long commented  ·   ·  Flag as inappropriate

        This should at least align with Excel cap limits. Many users filter their data using PowerBI and have to export for another purpose.

      • Aoife commented  ·   ·  Flag as inappropriate

        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.

      ← Previous 1 3

      Feedback and Knowledge Base

      Ready to get started?

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