Export Underlying data option does not show up

[Anonymous]

I am working in Power BI Desktop and want to export underlying data from a visualization.  These vizualiations are just in development and have not been published/shared. 

Power BI does NOT give me the following "Export data" window that lets me check the underlying data option. 

But instead goes directly to the "Save As" file directory screen, only exporting summarized data.

I have set the Export Data option "Allow end users to export both summarized and underlying data from the service".

I am sure I am missing some other setting, but I have not yet found it. 

Any suggestions?

Thank you ,

Mark

[HotChilli · Accepted solution]

"In Power BI online, if your visualization has an aggregate (one example would be if you changed Count to average, sum or minimum), you'll have two options: Summarized data and Underlying data. In Power BI Desktop, you'll only have the option for Summarized data"

[HotChilli · Accepted solution]

"In Power BI online, if your visualization has an aggregate (one example would be if you changed Count to average, sum or minimum), you'll have two options: Summarized data and Underlying data. In Power BI Desktop, you'll only have the option for Summarized data"

[Anonymous]

So the Underlying Data option is only available in Power BI Online?  

What is your source for the quote?

[v-cherch-msft]

Hi @Anonymous

Based on my research,underlying Data option is only available in Power BI Service. Below is the document about this feature for your reference.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?view=powerbi-ps#from-a-visualization-in-a-report

Regards,

Cherie

[Anonymous]

Hi Cherie - 

Thanks for the reference.

Honestly, I don't see where the article says the Desktop BI is limited to summarized data, or does not do underlying data.

Thanks,

Mark

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may find it under 'From a visualization in a report' part as below picture.

Regards,

Cherie