Export Underlying data option disabled

[Antmkjr]

Why this option is disabled suddenly? for all my reports?

[Anonymous · Accepted solution]

Hi @Antmkjr ,

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.

[GilbertQ]

Hi @Antmkjr 

You will need to chat to the person who looks after the settings for your report, as it looks like they have disabled this option.

[Antmkjr]

I myself is the admin  of the workspace. Some other reports , it is still showing the option.

Which option should i check for?

[hg1l8__]

Did you find a solution?