Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
Solved

Export Data - Data Exceeds the Limit

Hi,   I suspect this comes with the November update. When I try to do an Export Data from a Matrix or Table I am now getting a Data Exceeds the Limit error, I used to be able to Export data with a ...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    the documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.

     

    Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.

     

    These limits are described here:

    https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data

     

    Please don't ask me why such a limit exists :-) I'm just the messenger

     

    Regards

    Tom

Shelley's avatar
Shelley
Post Prodigy
7 years ago

LY18 Once the report is published to powerbi.com, hover over the visual you want to export and three dots should appear in the upper right corner. You can then select Export and continue exporting to Excel file format.

 

Prabhu_MDU's avatar
Prabhu_MDU
Advocate I
6 years ago

Hi Shelley , what version of the Power bi report.pbix file is ? because I am using october 2017 version of .pbix file and the report server is Jan 2019, still I am not able to find the mentioned option in the published report.

 

> Please provide a screen shot next to selecting the eclipse to export the file 

 

Thanks, 

Prabhu