Issue exporting report data to excel file

Hi maran ,

Please check these two points first:

1. Whether you have set the export data type as 'None' of the report.

2. If you are an admin of power bi service, please check whether you have enabled export to excel and export data in admin portal.

If you are not the admin, please contact you tenant administrator to check it.

In addition, there are some limitations about exporting data that you can refer:

• To export the data from a visual, you need to have Build permission for the underlying dataset.
• 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.
• The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000.

• Export using Underlying data won't work if:

  • the version is older than 2016.

  • the tables in the model don't have a unique key.

  • an administrator or report designer has disabled this feature.

• When using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

  • There are too many columns. Try reducing the number of columns and exporting again.

  • There's data that is difficult to compress.

  • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

• If the visualization uses data from more than one data table, and no relationship exists for those tables in the data model, Power BI only exports data for the first table.

You can also refer this document about exporting data in details that could help you: Export the data that was used to create a visualization 

Best Regards,
Yingjie Li

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