topic Re: Export Reports from Power BI Report Server in Report Server

Export Reports from Power BI Report Server

GuestUser — Fri, 05 Jul 2019 05:57:53 GMT

HI,

We have On-prem Power BI Report Server Installed (May-2019) .

We are not able to find an option to download/export the data in the reports in excel or pdf format

Any suggestion please?

Re: Export Reports from Power BI Report Server

d_gosbell — Tue, 09 Jul 2019 01:00:00 GMT

The export functionality only exists for paginated reports (rdl files). It does not exist for Power BI based reports (pbix files). If you need a data export you should build an rdl based report using report builder or SSDT

Re: Export Reports from Power BI Report Server

GuestUser — Tue, 09 Jul 2019 07:37:02 GMT

Thanks !!

Also could you please let me know if paginated reports created from Report Builder are visible on Power BI Mobile App( Report Server Link)

Since I am not able to see the paginated reports section on Mobile App

Though it is visible when accessed from desktop.

Re: Export Reports from Power BI Report Server

d_gosbell — Tue, 09 Jul 2019 20:59:11 GMT

GuestUser wrote:
Also could you please let me know if paginated reports created from Report Builder are visible on Power BI Mobile App( Report Server Link)

I'm not entirely sure as we don't use the mobile app where I am at the moment. Apparently official support for this was added in April https://powerbi.microsoft.com/en-us/blog/paginated-reports-now-supported-in-apps-in-power-bi/ I'm assuming that this is specifically supported on PowerBI.com, but I would hope that the May 2019 release of PBI Report Server would include this.

Re: Export Reports from Power BI Report Server

Anonymous — Wed, 25 Sep 2019 15:00:06 GMT

Hi,

is the export functionality in excel expected in the next release of power bi report server?

Re: Export Reports from Power BI Report Server

messerjc — Tue, 18 Feb 2020 23:53:41 GMT

Looks like we now have that ability in the January 2020 release.

https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2020-feature-summary/#reporting

Re: Export Reports from Power BI Report Server

d_gosbell — Wed, 19 Feb 2020 00:54:14 GMT

messerjc wrote:

Looks like we now have that ability in the January 2020 release.

https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2020-feature-summary/#reporting

messerjc so that feature adds the ability for us to export the data behind a single visual to Excel (it used to only export to csv). But it does not include the ability to save the entire report in PDF or Excel.

Re: Export Reports from Power BI Report Server

GuestUser — Wed, 19 Feb 2020 05:55:45 GMT

Hi,

Thanks !!

Just a question - in Power BI Cloud , can we export the visual in the excel in exact format as shown on front end

Re: Export Reports from Power BI Report Server

d_gosbell — Wed, 19 Feb 2020 10:09:39 GMT

GuestUser wrote:

Just a question - in Power BI Cloud , can we export the visual in the excel in exact format as shown on front end

You can export the whole report to PDF or Powerpoint from the Power BI Cloud, but you can't do this to Excel and I don't think there is anyway to do a single visual (other than just taking a screenshot and pasting it into Excel)

Re: Export Reports from Power BI Report Server

Anonymous — Mon, 12 Apr 2021 13:04:04 GMT

Hi d_gosbell
What about this article: https://docs.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-server-ver15
I can see there's an export as PDF, Will that work as a download option ?
besides, practically I could not apply it on a report I have .. any help please ?