2

We have designed the report which has Pie and bars chart would need to download the entire report as an excel with the Chart representation.

Currently, the report is embedded in the SharePoint page. Would need to download the report from the embedded page, using a Download button.

DataSoruce: SharePoint list. Report embedded in SharePoint Page.

Is there any way we can download the entire power bi report as excel?

Nanda
  • 49
  • 1
  • 6

1 Answers1

2

There is no export Report to Excel for standard Power BI reports.

With standard Power BI you cannot export the report as Excel, just PDF and PowerPoint. You can use Analyse in Excel to connect to the data model in the service, but you will have to recreate the visuals from the pivot table.

enter image description here

You can Export to Excel with Power BI Paginated Reports, but you'll need Premium, Premium Per User or Power BI Report Server to use this type of report. You'll be able to export in HTML, MHTML, PDF, XML, CSV, TIFF, Word and Excel.

If the report is embedded into an object like SharePoint you may be able to add an object that calls the API. This will be dependant on the license type you have to access the API, Power BI Embedded EM SKU etc. This will still result in the same export types for Power BI, PDF and PPTX, but also comes with and image file (PNG as default) and Power BI Premium/Per User options outlined above.

Jon
  • 4,593
  • 3
  • 13
  • 33
  • Currently, the report is embedded in the SharePoint page. Would need to download report from embedded page, using a Download button. – Nanda Apr 23 '21 at 04:28
  • Updated answer to give an option via the PBI API. However for standard PBI reports there is no export to Excel. – Jon Apr 23 '21 at 09:58
  • will the below api can be used - https://learn.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile – Nanda Apr 23 '21 at 13:11
  • Where to check the capacity – Nanda Apr 23 '21 at 13:12
  • If your work space has a premium capacity it will show in the admin setting or a small Dimond icon on the workspace it self, and in the workspace setting – Jon Apr 23 '21 at 13:48