Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exporting Tabular

Hi,   Does anybody know if the new feature that was listed for the January 2020 update   "Ability to export data to Excel from a tabular visual in the Power BI Report Server so that users can ana...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thats strange - After publishing a graph on to the report and removing, its now displaying the three dots for the table.

     

    Thanks again d_gosbell 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Export underlying data
  1. Select the ellipsis from the upper-right corner of the visualization. Select Export data.
  2. From Export data, select Underlying data, and then select Export. Power BI exports the data.
  3. When you select Export, your browser prompts you to save the file. Once saved, open the file in Excel.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

 

Hi Lewis,

 

Many thanks for the reply! Would it be possible to send a screenshot of it?

 

Im just wondering whether it's if the update hasn't gone through for me, or if im missing it completely.

 

Thanks again.

 

Liam

  • d_gosbell's avatar
    d_gosbell
    Super User
    6 years ago

    I just checked on my Jan 2020 install and when I choose Export Data it now comes up with the following dialog which lets me choose between xlsx or csv for the file format (defaulting to xlsx)

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi d_gosbell ,

       

      Just to confirm, is this on the report server?

       

      I have the January 2020 install and I have no elipsis on my table to select export?

       

       

      Thanks

       

      Liam

      • d_gosbell's avatar
        d_gosbell
        Super User
        6 years ago

        Yes, this is on the report server.

         

        But you can turn off the access to the ellipsis by turning off the Visual Header on the visual from the properties pane when you edit the report in Power BI Desktop.