Export underlying data option disabled in Table Visual

Hi basirve ,

Please select Allow end users to export both summarized and underlying data from the service option from the Power BI desktop.

In the Service:

• 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.

• Export using Underlying data won't work if you enable the Show items with no data option for the visualization Power BI is exporting.

Please refer to the doc:
Export data from a Power BI visualization - Power BI | Microsoft Docs

Hope that's what you were looking for.

Best Regards,

Yuna

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