Forum Discussion

ShrutiJ's avatar
ShrutiJ
Helper II
5 years ago

Export functionality exports less rows in excel

I have a report with table visual which has ~80K records and published in a workspace. When I export the data of this visual, it exports ~28K records only although the limit is 150K. When I remove fe...
Need Help
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, ShrutiJ 

According to your description, you said that “it exports ~28K records only although the limit is 150K.” But I found that the limitation is around 30K in the document, you can check this:

  • The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.

Link of the limitations

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ShrutiJ's avatar
    ShrutiJ
    Helper II
    5 years ago

    Hi v-robertq-msft ,

    I'm exporting it in an excel. Hence, expecting to have a limitation of 150K.

    • "The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000."

    As I mentioned, on reducing the number of columns the records increased, I could go upto 40K. 

    Not sure if there is some limitation here on the number of columns also. Need help to understand this.

    • v-robertq-msft's avatar
      v-robertq-msft
      Community Support
      5 years ago

      Hi, ShrutiJ 

      Can the Excel specifications and limits document shared by aj1973 help you to find the true reason that limited you?

       

      Best Regards,

      Community Support Team _Robert Qin

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.