underlying data option is disabled under export data

[jatneerjat]

Hi,

I want to export underlying data of a visual to csv or excel but the option is disabled and it also shows message that "due to structure of data we are not able to support the export to .xlsx file".

how can i get underlying data?

thanks

[prihana]

This seems an odd issue. Please provide more information. What is the data source? Hopw are you accessing (Direct Query / Import)?

[jatneerjat]

Hi @prihana

I am fetching data from on premise sql server and use this data in circular gauge.

[v-frfei-msft]

Hi @prihana,

Based on my test, I cannot reproduce your issue here. If you use live connection ,could you please check your version of SSAS?  As exporting Underlying data will not work if the data source is an Analysis Services live connection and the version is older than 2016 and the tables in the model do not have a unique key. For more details, please check the online document. One more thing, I got this kind of error message as I did not add aggregated columns to my chart..

In addition, What is your data type of the columns? Could you please share your pbxi to me?

Regards,

Frank