Export from Power BI report embedded in SharePoint Online web part

[chellemcg]

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?

[v-deddai1-msft]

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 · Accepted solution]

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:

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic