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

Export from Power BI report embedded in SharePoint Online web part

I have embedded a Power BI report in a SharePoint Online Power BI web part in a modern site page. Users can view the data, filter it, and move between the various report pages. However there does not appear to be an option to export the data to Excel. Is it not possible to retrieve the underlying data from the report?

1 ACCEPTED SOLUTION
selimovd
Community Champion
Community Champion

Hey @chellemcg ,

 

one thing upfront, I don't know if it's possible to dwonload the underlying data when the report is embedded in Sharepoint.

But check the following requirements to be able to download in general:

If you can or cannot export the underlying data depends if the user has the build permission:

Build permission for shared datasets - Power BI | Microsoft Docs

 

The permission can be set by user individually or by AD group.

Also be aware that you can disable the export in the report itself:

selimovd_0-1619108684662.png

 

 

So you might have to check both options.

If both options are set correctly check if the user can download in PowerBI Service. Then check if it's possible in the embedded Sharepoint.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

2 REPLIES 2
v-deddai1-msft
Community Support
Community Support

Hi @chellemcg ,

 

The export data function supports in power bi embbed (it is not supported in publish to web). As mentioned by selimovd, you should have build permission on the dataset and you set correctly in power bi desktop.  

 

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

 

Best Regards,

Dedmon Dai

selimovd
Community Champion
Community Champion

Hey @chellemcg ,

 

one thing upfront, I don't know if it's possible to dwonload the underlying data when the report is embedded in Sharepoint.

But check the following requirements to be able to download in general:

If you can or cannot export the underlying data depends if the user has the build permission:

Build permission for shared datasets - Power BI | Microsoft Docs

 

The permission can be set by user individually or by AD group.

Also be aware that you can disable the export in the report itself:

selimovd_0-1619108684662.png

 

 

So you might have to check both options.

If both options are set correctly check if the user can download in PowerBI Service. Then check if it's possible in the embedded Sharepoint.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!