Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

What is the Export data row count limit for Power BI Report Server?

We seem to be limited to exporting 30,000 rows of data with Power BI Report Server, but we can export 150,000 rows in Power BI Service.  Is there an official row limitation for Report Server and is a...
data export
Export Data
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    After confirmation from PG internally, we can only export data to .csv currently. And maximum number of rows that can be exported .csv is 30,000.

     

    Best Regards,
    Qiuyun Yu

Rookarumba's avatar
Rookarumba
Icon for Helper III rankHelper III
8 years ago

That is another way to look at it.

 

Basically what I did is, I extracted the entire raw data after some processing and load it onto an Excel sheet and asked the user the work on those file and use PowerBI as a visual :(

 

This is really a huge shortfall and bad for everyone that is using PowerBI Report Server or the team that build it :(

oranimo's avatar
oranimo
Icon for Advocate I rankAdvocate I
8 years ago
Note that in latest versiion of PBIRS March 2018, Export data to csv does not work at all from the web portal. It only work from the desktop application optimized for PBIRS March 2018, but fails once the file is successfuly uploaded to the web portal. Please check and update on a fix. If anyone else noticed the same bug then please report it here.
  • SaphireRose's avatar
    SaphireRose
    Icon for Advocate I rankAdvocate I
    8 years ago

    I also can't export data from the Power BI Report Server March 2018 version. I click on the Elipses, select "Export data", and then...nothing....

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the heads-up!  We will wait until this fixed before we move to the March version of PBIRS.

  • PatrickSeidl's avatar
    PatrickSeidl
    Frequent Visitor
    8 years ago

    Same issue with PBIRS Version 1.2.6648.38132 (March 2018) 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi PatrickSeidl,

       

      Export data is fixed with the latest build. 

       

      Please make sure to clear your browser's cache.

      • PatrickSeidl's avatar
        PatrickSeidl
        Frequent Visitor
        8 years ago

        Hi Anonymous,

        all I found is Version 1.2.6660.39920 (March 2018) and with this one it is still not working for me, even with a filtered, smaller list.

         

        I assume this is the version you are refering to, right?

         

        Cheers,

        Patrick