Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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