Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.