underlying data in power bi not coming Error message as visual does not have aggregates or measure

[Anusha__v]

Hi,

While exporting the data I do not see the underlying data option.

underlying data in power bi not coming message is displaying as visual does not have aggregates or measure.

In Power BI Desktop, I tried to select File > Options and Settings > Options > Current File > Report Settings, then under Export Data subtitle, enable “Allow End Users to Export Both Summarized and Underlying Data from the Service.”

But still, I do not see the underlying data option.

Can anyone help me.

Thanks

[k_s]

Why do you need to do this? does anyone ever question how insanely buggy and backwards PowerBI is? This seems like some kind of sad workaround.  This export used to work just fine for me and my users and all of a sudden it doesn't. What happened? Did Microsoft push some kind of change without telling people? What's with the aggregation requirement?
Does anyone here ask questions or do they just accept the very expensive trash that they are selling us?

[v-yueyunzh-msft · Accepted solution]

Hi , @Anusha__v 

According to your description, you are trying to export underlying data in Power BI Service and you receive an error message that says "Visual does not have aggregates or measures", it means that the visual you are trying to export does not contain any aggregated data or measures that can be exported.

To export underlying data, the visual must contain at least one measure or aggregated data. If the visual does not contain any measures or aggregated data, you can try adding a measure or aggregated data to the visual and then exporting the data again.

Underlying data represents the underlying data, and it's possible that your current visual only contains existing data in the table, so you only need to use the first two export methods.

For more information, you can refer to :
How To Export Underlying Data in Power BI (designmind.com)

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[Anusha__v]

Thanks