Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Export underlying data

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 ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

  • arielfilipa's avatar
    arielfilipa
    9 years ago

    Hi,

     

    I'm also having the same problem and from my side the issue is that I'm using a calculated measure and I'm trying to find some option to solve this but still no luck :-(

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Based on your screenshot, I note that you apply filters to your Matrix visual, and it seems that all underlying data has been exported in Excel, but the data is displayed in different format as that in Matrix visual.  Would you mind sharing me the original sample file or PBIX file?

Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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