Exporting data

[ash_y]

I want to publish a report created in PowerBI Desktp to PowerBI Service and export table data on the viewer side.
Only certain visuals do not show a toggle to export.
What could be the cause?

*We have a setting that allows exporting data.

Only certain visuals do not show the buttons in the following images.

[lbendlin]

Please clarify "certain".  Is that a  treemap visual?

[ash_y]

Hello @lbendlin 

Im sorry for the delay in responding.
This happened with the table visual, not the treemap.
The cause was that the header icon in the format pane was inactive.
Thank you for your reaction.

[v-hjannapu · Accepted solution]

Hello @ash_y,
Thank you  for reaching out to the Microsoft fabric community forum.

If the "Export data" option is missing for only some visuals, This usually happens because of a few common reasons. Some visuals, especially custom ones, don’t support export. Try using basic visuals like bar chart or table and see if the option comes. Also, in Power BI Desktop, each visual has a setting to allow export. You can check it by clicking on the visual, going to the Format pane, and making sure the "Export data" option is turned on in the visual header. Sometimes, if your report is using row-level security or if export is limited to summarized data in admin settings, the button may not show. Try changing the visual type or checking the settings in Power BI Desktop, then publish again. 

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.

[Carsten72]

Hi @v-hjannapu 

I have the same issue on published reports and may need a bit more help 😉 Fairly new to PowerBI.

By "Format pane", do you mean as shown below?

If so, where to go from here to turn on "Export data" option?

If not, where do I find the correct "Format pane"?

Regards

Carsten

[ash_y]

Hello @v-hjannapu 

Thank you for your response.
The header icon in the format pane was inactive.

By changing it to active, we are now able to export.

Thank you so much.

[v-hjannapu]

Hi @ash_y,
Thanks for confirming that your issue is resolved! If you found the solution helpful, please consider clicking ‘Accept as solution’  it can help others who come across this thread.
If you have any further questions, feel free to reach out.
Regards,
Harshitha"

[v-hjannapu]

Hi @ash_y,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.