SSRS to PowerBI

[alicebotteri]

Hi guys, 

I have a tabular report in SSRS and I want to know if is possible to embedded it into a powerBI solution.

Any one could help me ? 

Thanks

Alice 

[v-xjiin-msft · Accepted solution]

Hi @alicebotteri,

As I know currently it is not supported to embed SSRS report into Power BI desktop. 

But you can pin a SQL Server Reporting Services (SSRS) report to Power BI Dashboards. By doing this, there's few options you should be mentioned. 

1. First, credentials must be stored in the report in order for the object to refresh. The pinning process actually creates a SSRS subscription which requires stored credentials in order to execute.
2. Furthermore if you change the item name, the object will stop updating based on the subscription. Also if the pinned object is deleted, the related subscription is not deleted and must be removed manually.
3. Lastly, if you try to pin an object and the SQL Server Agent is not running, the following error results. The SQL Server Agent where the SSRS database resides must be running in order to pin objects.

For more details, please refer: Pinning a SQL Server Reporting Services Report to Power BI 

Or you can upload your SSRS report to Power BI on-prem report server. 

https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-paginated-report 

Thanks,
Xi Jin.

[Greg_Deckler]

Sort of, but perhaps not exactly what you want. See this blog article

http://biinsight.com/ssrs-2016-power-bi/