Forum Discussion
PowerBI + SSRS Live Connection?
ankitpatira
Thank you for your fast request:
I have found this article: https://blogs.msdn.microsoft.com/samlester/2016/04/18/power-bi-ssrs-2016-in-an-on-premises-environment/
In my understanding it`s possible to load a pbix. File into SSRS but don`t view this in the browser.....
What I would love to see is the ability to leverage Power BI Data Sets deployed to the Power BI Service for other reporting clients such as SQL Server Reporting Services. It is already so close from the analyze in excel using the Provider=MSOLAP to connect. I would love to be able to leverage a dataset with a visusal interactive dashboard and reporting tool like Power BI, as well as a nice PDF/Page Layout/Generl reporting tool like SQL Server Reporting Services.
Between Live Connection in Power BI Desktop and Analyze in Excel Connections, it can't be that difficult to expose to SSRS to connection to a Power BI Data Set for reporting purposes.