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 

d_gosbell's avatar
d_gosbell
Super User
6 years ago
Anonymous wrote:

Is there anything else that could affect this?

 

All I did was to run the upgrade on my instance and this new feature started working on existing reports, I did not have to do anything to enable it.

 

For PBIRS I think you can either turn off the Visual Header entirely or just turning off the More Options setting for an individual visual. Or Exporting can be disabled at the server level, but I would not expect that to hide the ... menu as there are other options in there.

 

If you (or an admin) connect to your PBIRS server using SSMS to connect to http://<servername/ReportServer you can right click on the server and view it's properties, under the advanced settings you can see the following options. The highlighted options show where you can turn off exporting at the server level.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi d_gosbell 

 

Many thanks for all of your replies. 

 

It seems it doesn't work for exporting a table - which is what I was aiming for.

 

It let's me export from a graph, but not table matrix.

 

Thanks

 

Liam