cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BBIUser Member
Member

Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Hi,

 

1) Is there any other way that an Admin or Dataset Owner can give permissions through Apps to end users to export the visual data (Table / Matrix, or any visual) to Excel or CSV, where Apps having the READ ONLY permissions to the end users?

If not, How should an Admin or Dataset Owner provide the end user the permission to export to excel or CSV from Apps?

- In my use case, the end users should not have the edit rights to reports nor they can have build permissions.

 

Please help me. Thanks in Advance!

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Hi @BBIUser 

 

You can click on the Report Settings in your report and configure how the data can or cannot be exported.


Below is a screenshot of where you can configure the settings.

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

Community Support Team
Community Support Team

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Hi @BBIUser 

As tested, when i download an Power BI App from my organization,

i have only read permission to this App,

i can export data from the visuals on the reports.

 

Please check if your Admin or report builder give the "export data" permission.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

 

For Admin, under Admin protal->Ternat setting, trun on "export data"

https://docs.microsoft.com/en-us/power-bi/service-admin-portal#tenant-settings

 

For a report which publishing from Power BI Desktop, check the "export data" option under File > Options and Settings > Options-> CURRENT FILE, select Report settings.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Hi @BBIUser 

 

You can click on the Report Settings in your report and configure how the data can or cannot be exported.


Below is a screenshot of where you can configure the settings.

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

Community Support Team
Community Support Team

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Hi @BBIUser 

As tested, when i download an Power BI App from my organization,

i have only read permission to this App,

i can export data from the visuals on the reports.

 

Please check if your Admin or report builder give the "export data" permission.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

 

For Admin, under Admin protal->Ternat setting, trun on "export data"

https://docs.microsoft.com/en-us/power-bi/service-admin-portal#tenant-settings

 

For a report which publishing from Power BI Desktop, check the "export data" option under File > Options and Settings > Options-> CURRENT FILE, select Report settings.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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

BBIUser Member
Member

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Thanks for the reply @GilbertQ and @v-juanli-msft 

Gilbert: I had that option checked in the Report Settings.

 

Maggie: I suppose the problem was "export data" permission which gives them permission to build reports, and dashboards from that dataset and also export option. I dont see any problem by selecting this option for my use case. 

 

But, is there any consideration to seprate the "export data" (to Excel or CSV) from within "build permissions" for READ ONLY Apps? Has anyone submitted idea on this type of request?

 

Appreciate it!

 

Super User IV
Super User IV

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Hi there, I am not aware of any idea for this request. Possibly create one, it is a valid idea




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
BBIUser Member
Member

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

Sure @GilbertQ . I will post this request. Thank You!

BBIUser Member
Member

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

If any of you have this similar need. Please place your VOTE for this Idea:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38097136-separate-settings-for-ex...

gelliott02 Regular Visitor
Regular Visitor

Re: Any other alternatives for Power BI Apps Users to export the visual data to Excel or CSV?

(DJ Khaled voice) "And another one"

 

Rollback to export to excel without build permissions on dataset please. It was a mistake. We forgive you.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors