cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GuestUser
Helper V
Helper V

Export Reports from Power BI Report Server

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?

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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

View solution in original post

9 REPLIES 9
d_gosbell
Super User
Super User

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

View solution in original post

mazer
Frequent Visitor

Hi @d_gosbell 
What about this article: https://docs.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-se... 
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 ?

Hi,

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


@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/#report...

 


@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.

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


@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)

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.


@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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.