Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help: Export all data table to excel

Hi all!!    I have this question, about power bi service; I have a table with 60 columns and in the report I only show 10 columns, when the information is exported to excel, there is a way to downl...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi Anonymous,

     

    Here I made a test to export all columns of a table if only part of columns were added in one visual. Firstly, we need to change the columns that were not added into the visual to text type in advance in desktop. Then publish the report to service. After that, we can get all the columns of the table through exporting data of the visual.

     

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi Anonymous,

 

Here I made a test to export all columns of a table if only part of columns were added in one visual. Firstly, we need to change the columns that were not added into the visual to text type in advance in desktop. Then publish the report to service. After that, we can get all the columns of the table through exporting data of the visual.

 

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Frank, 

    Thanks for your help, Its work perfect for me.

     

    Regards,

    Mónica