Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Export Excel online table

Hi, 

 

How to export data from Report Server on Excel without comma ? Because it's really difficult to change data after all. 

My client need to export all the tables from my report on Excel. 

 

 

Thanks by advance for your help, 

 

Have a nice day, 

Excel
Export
Report Server

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    This has to be done, table by table or visual by visual. One shot export of all the tables to excel is not available in Power BI Report server. You can export to PDF from PBI desktop.

     

    By default, when data is exported to excel from table/visual, it comes in very decent format with columns seperated in excel.

     

    Thanks

    Manoj

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous 

       

      Actually, no it's not in a very decent format. 

      Datas are not separated in columns , and there's commas everywhere.

       

      My question was : is it possible to export datas from table in Excel but not on this form, I would like to have the same table on Excel without any data manipulation to do. 


      Thanks by advance !!