cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tangcy123
Helper I
Helper I

How to export visual data directly, instead of clicking on ... then clicking on export button

There are many visual data / table reports in my power bi, everytime I have to click on "...", then click on export button, then export the data to csv file,  it costs much time for me to export each report.

Question:  Is there any good way to add a button to click on and export visual data directly?  

 

 

tangcy123_0-1655364437249.png

 

1 ACCEPTED SOLUTION
v-polly-msft
Community Support
Community Support

Hi @tangcy123 ,

f you do have permissions to the data, you can see and export the data that Power BI uses to create a visualization.

If you don't have permissions to the data, you won't be able to export or open in Excel. Often, data is confidential or limited to specific users.

 

Power BI report designers control the types of data export options that are available for their consumers. The choices are:

  • Allow end users to export summarized data from the Power BI service or Power BI Report Server

  • Allow end users to export both summarized and underlying data from the service or Report Server

  • Don't allow end users to export any data from the service or Report Server

More details: Export the data that was used to create a visualization 

 

If you find that you can't use this feature, reach out to the report owner and your administrator to understand why you can't export data from a particular visual or from all visuals. It may be that this feature has been purposely disabled and perhaps they can enable it for you. Other times, there may be particular reasons an export does not work. It could be related to permissions, data contents, data type, visual type, how the designer named the fields, and more.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-polly-msft
Community Support
Community Support

Hi @tangcy123 ,

f you do have permissions to the data, you can see and export the data that Power BI uses to create a visualization.

If you don't have permissions to the data, you won't be able to export or open in Excel. Often, data is confidential or limited to specific users.

 

Power BI report designers control the types of data export options that are available for their consumers. The choices are:

  • Allow end users to export summarized data from the Power BI service or Power BI Report Server

  • Allow end users to export both summarized and underlying data from the service or Report Server

  • Don't allow end users to export any data from the service or Report Server

More details: Export the data that was used to create a visualization 

 

If you find that you can't use this feature, reach out to the report owner and your administrator to understand why you can't export data from a particular visual or from all visuals. It may be that this feature has been purposely disabled and perhaps they can enable it for you. Other times, there may be particular reasons an export does not work. It could be related to permissions, data contents, data type, visual type, how the designer named the fields, and more.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ribisht17
Super User
Super User

@tangcy123 

 

Solved: Create a button to export data to excel - Microsoft Power BI Community

 

This should be helpful, if you are looking for a button, I am afraid if it is there

 

Regards,

Ritesh

 

ribisht17
Super User
Super User

@tangcy123 

 

Power BI currently does not allow exporting data of all visuals at once to excel/csv.

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

Hi ribisht17,

Is it possible to export data of one custom visuals at once to excel/csv?  

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors