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,

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

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
    7 years ago

    Hi

     

    I am struggling with the same issue.

     

    export to underlying data is grayed out and error message was that i dont have permissions.

     

    is this something to do with Admin permissions?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous Sounds like it. Power BI tenant settings allow you to disable exporting data, you would need to speak with your Power BI or Office 365 admin to enable this for you if you needed it.