Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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 analyze data"

 

Is included or has it been left out?

 

Thanks in advance

 

Liam

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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 

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

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
Not applicable

@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

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)

2020-01 export.png

Anonymous
Not applicable

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

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.

Anonymous
Not applicable

Hi @d_gosbell 

 

Is there anything else that could affect this?

 

I have report server: Version 1.6.7327.3007 (January 2020) 

 

With no option to edit the table in any way.

 

Thanks

 

Liam


@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.

 

2020-01 pbirs adv options.png

Anonymous
Not applicable

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
Not applicable

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

Anonymous
Not applicable

@d_gosbell 

 

This is strange, they were all turned on.

 

I have two tables with no sign of elipsis. I have it on the desktop version but not report server.

 

Could it be anything else? 

 

 

 

Visualheader.png

 

Thanks for your help with this.

 

Liam

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors