Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
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.
I myself is the admin of the workspace. Some other reports , it is still showing the option.
Which option should i check for?
Did you find a solution?