Export underlying data

[Anonymous]

HI

I am exporting underlying data from my report(Matrix), and i am getting the correct count of rows, but all columns are not included in the excel data, i wants to export the data with all columns which are there in source table, is there any way to do this. Can anyone help me on this. Thanks in advance

Rajmohan 

[Anonymous · Accepted solution]

Hi @Anonymous,

I got information that when using the “export underlying data” option in Power BI Service, the export file will contain columns which are used to create the visual together with all “Text” type columns. If you want to export all columns, you would need to set the rest columns to be “Text” type  or include the rest columns in your Matrix visual.

Thanks,
Lydia Zhang

[rintoalappat]

any update on this ? Im too having the same issue.

[Anonymous]

Hi @Anonymous，

Thanks for sharing me your original file and PBIX file. I test your PBIX file and reproduce this issue.

I create another Matrix visual use my sample data file(Financial Sample.xlsx), then export underlying data of the Matrix visual and find out that Power BI Service only exports some columns. I don't figure out how it chooses columns to export, I will report this issue internally and post back once I get any updates.

Thanks,
Lydia Zhang