Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Sort of, but perhaps not exactly what you want. See this blog article
http://biinsight.com/ssrs-2016-power-bi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |