cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MJMcbride Frequent Visitor
Frequent Visitor

Microsoft SSRS report subscription capability on Power BI server

I currently manage around 200 report subscriptions on a 2008 R2 SSRS system. 2008 R2 is at end of support so we are looking at our upgrade path options and are considering moving to the Power BI platform. The main concern is the ability to have the same subscription options we have now, mainly either emailing the report results in Excel format or writing Excel files to shared drives on our network on a automated schedule.

 

It is not clear to me that the Power BI platform can do that? Can someone point me to information on this?

 

 

1 REPLY 1
Super User
Super User

Re: Microsoft SSRS report subscription capability on Power BI server

It depends on what you mean by the "Power BI platform" this forum is specifically focused on Power BI Report Server which is the on-prem install. This product is pretty much SSRS 2017 with the extra capability of rendering pbix reports so pretty much anything you can do in SSRS 2008R2 you can do in PBIRS.

 

If you are talking about the Power BI Service (ie. powerbi.com) then the ability to render rdl based reports is relatively new. The following docs have some information on what you can do there https://docs.microsoft.com/en-au/power-bi/paginated-reports-subscriptions - it can definitely render to Excel format and send emails. But I don't believe that the service can write to file shares (I think email is the only option at the moment)

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 204 members 2,084 guests
Please welcome our newest community members: