Export Underlying data option disabled

Hi Anonymous ,

If you click the prompt message, it shows  “ You don't gave permission...” as shown below:

Please go to the report -->Click "More options"-->Select "Summarization data and underlying data" under Export data option:

Then the prompt message will change to "You must first an aggregate to your chart..."

Based on my test, you could simply add a measure to the visual and then you could export underlying data successfully, please see the differences:

Refer to :

Work with aggregates (sum, average, and so on) in the Power BI service - Power BI | Microsoft Docs

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