Display PowerBI report in SSRS / Sharepoint

[abhinavs2016]

Hi,

We have a requirement to display PowerBI reports in SSRS. 

Is that possible ?

Else can we display powerBi report in a sharepoint webpart.

[v-yuezhe-msft]

Hi @abhinavs2016,

Currently, we are not able to directly display Power BI reports in SSRS, some ideas about this issue have been submitted in the following links, please vote it.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15368898-pbix-rendering-in-ssrs-2...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13833282-run-power-bi-and-ssrs-re...

However, you can host the Power BI Desktop(.pbix) file in SSRS 2016 as stated in this blog. When the user clicks on the file, they will be required to open it in Power BI Desktop on their local machine and view visuals in Power BI Desktop.

In addition, do you want to embed Power BI report in SharePoint site? If that is the case, you can use Publish to Web feature to achieve this, for more details, please review this blog. In this blog,  you can learn how to create a SharePoint web part page to host your Power BI report.

Thanks,
Lydia Zhang