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.

396 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 →

    33 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...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Lets make Power BI proper Reporting tool. Every reporting tool must be offering capability of exporting millions of rows to Excel. Otherwise tools sucks :D.

        Now seriously, there should be limit around 1-3M cells to be exported. This is what we have available in SAP reporting tools.

      • Q commented  ·   ·  Flag as inappropriate

        Data export row limitations should be removed with the option of configuring the limitations available for developers (for load planning purposes).

        With the release of Power BI Report Server, on-premise users who view web versions of the reports are limited to 30k rows of data to export.

        Power BI reports are often used as an interface by business users to obtain data as if they are running SQL queries. If there is no way to export the data out of Power BI if the result set is more than 30k, the data is basically stuck in the Power BI interface and not useable in other workflows.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Maximum limit to export should match the max limit of Excel. If it fits in Excel is should be able to be exported, If it doesn't fit in your Excel then it is too much to export.

      • Ralf commented  ·   ·  Flag as inappropriate

        The export limit to 30k rows (or even 150k for Pro) disqualifies Power BI as a reporting tool. It will definitly not be introduced in our company.

      • Doug Verhaalen commented  ·   ·  Flag as inappropriate

        Definitely support a higher limit. Also, why can't I export to XLSX from a table when no aggregates are in the table?

      • Greg commented  ·   ·  Flag as inappropriate

        Removing the limit would be a huge step to give Power BI even more power and to become a stronger alternative to Tableau

      • Anonymous commented  ·   ·  Flag as inappropriate

        Major roadblock to convincing decision makers about the efficiency of using Power BI when compared to other platforms. Please remove this constraint --

      • Martin commented  ·   ·  Flag as inappropriate

        This limit is a major blocker for using PowerBI with my Investment Banking client, many of their reports need to go out to customers in Excel format and can be up to 300k records, I presume this issue is related to limiting memory resources on the server? Can this not be overcome?

      • Jeffery Morris commented  ·   ·  Flag as inappropriate

        We are really limited on rolling this out due solely to this issue.

        It is also odd that there is no warning (at least when exporting from a matrix). My data stopped around 38k rows (there was supposed to be 200k) and I only happened to notice because the totals were off.

      • Antonio commented  ·   ·  Flag as inappropriate

        Definetively, improving export limits will become very useful when working with lots of data, since I need my team to action several reports for more than 150K lines. Totally love Power BI, but that is something Tableau can do and Power BI cannot.

      • Luis Lucchini commented  ·   ·  Flag as inappropriate

        Increasing (or removing) this limit would certainly take our usage of power bi to the next level with the combination of the efforts from several of our teams. Excited to see increased integration of Power BI and R!

      • Aaron commented  ·   ·  Flag as inappropriate

        will these limits be extended to Power BI Reporting Services as well. And also in the Power BI SSRS executable?

      • Ira Saktor commented  ·   ·  Flag as inappropriate

        The use of R programming with PBI would benefit greatly from increasing this limit to way higher numbers. 150.000 is a real constraint if you have to work with higher frequency data.

      • Ashley Reilly commented  ·   ·  Flag as inappropriate

        The export amount should be limited to the source file, such as the max rows available in Excel is what I should be allowed to export.

      • Tyler L. commented  ·   ·  Flag as inappropriate

        I need to export a couple millions rows a data and it would be nice to allow PowerBI to export to CVS with no limits on the size. For an Excel export, the limit should be equal to Excel's maximum row limit.

      • mg commented  ·   ·  Flag as inappropriate

        Power bi , could be used as a great ETL tool. For data migrations. Its data prep tools, are excellent - yes , it would data migrations so easy. You have a wider audience./market than you know..think outside the box.

      ← Previous 1

      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.