Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Export Underlying data option disabled

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

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • Hi Anonymous 

     

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

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

      Which option should i check for?