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,

Do you take the operation that export data in Power BI Service or in Power BI Desktop? If you export data in Power BI Service, please help to post screenshots about your scenario. Also try to create Matrix visual in Power BI Desktop and check the export result.

If you are using Power BI Desktop, would you mind sharing me the PBIX file with which I can  test?

 

Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous

I am taking export operation from power bi service after publish the report from desktop, i have created matrix in desktop then i exported the data it is giving only summarised data, from power bi service if i export the data with underlying data option it is exporting data to excel file with 33 columns only, and i have around 50 columns in the table which i used for the report, my requirement is i need all the columns to be exported in the excel file from power bi service while exporting data, i am attaching screenshots of power bi service, desktop and excel file. Please check and help me out on this.export data from serviceexported file column count is 33desktop in the right you can find the table with around 50 columns

 

Thank you

Rajmohan

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • Sreya's avatar
      Sreya
      Helper II
      5 years ago

      Anonymous 

      Hi, When I am exporting underlying data then only 1 row i.e 'Total' row of the Matrix is getting exported but not the whole data. Can you tell me why it is happenning?

    • rmettu_1242's avatar
      rmettu_1242
      Advocate II
      9 years ago

      Hello,

       

      I am try to export the data from Detail report in Power BI Services ," Underlying data" option grade out for one report rest of the report was able to export the data into excel.

       

      Why only one report having an issue?

      I noticed that when we export data from details report .  other columns exporting into spreadsheet which are not part of the detail report

        

       

       

       

       

      • arielfilipa's avatar
        arielfilipa
        Advocate I
        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
      8 years ago

      I am missing two of the three value columns that are present in the visual during export.  The other visuals using the same tables are providing all the value columns during export.

       


      Seems odd to me that the visual showing all the value columns is only exporting one, but the visuals only showing one value is exporting all of them.

  • 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

    • rintoalappat's avatar
      rintoalappat
      Frequent Visitor
      2 years ago

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