Forum Discussion
PowerBI + SSRS 2016
dalisaydavid The simple answer is "You can keep this all on-premises"
The longer answer, and what the blog refers to, is that you can integrate your Power BI Service with SSRS and interchangeably use SSRS report elements in the PBI Service, as well as see Power BI Reports in SSRS.
The differentiator here is that you are only using the Power BI Desktop (free download) to visualize those reports in SSRS, there is no cloud service involvement. SSRS currently supports you uploading that PBI Desktop file to the SSRS server. So, your scenerio is supported, and all your data will stay on premises.
From my understanding, the display and use of those report files in SSRS will get better with time as well.
dalisaydavid The simple answer is "You can keep this all on-premises"
The longer answer, and what the blog refers to, is that you can integrate your Power BI Service with SSRS and interchangeably use SSRS report elements in the PBI Service, as well as see Power BI Reports in SSRS.
The differentiator here is that you are only using the Power BI Desktop (free download) to visualize those reports in SSRS, there is no cloud service involvement. SSRS currently supports you uploading that PBI Desktop file to the SSRS server. So, your scenerio is supported, and all your data will stay on premises.
From my understanding, the display and use of those report files in SSRS will get better with time as well.
Anonymous,
That makes perfect sense, thank you.
What I need is to use the Power BI reports inside of SSRS - which is one of the perspectives you posed.
And this seems to be a great option for us. I found a tutorial blog found here: https://blogs.msdn.microsoft.com/samlester/2016/04/18/power-bi-ssrs-2016-in-an-on-premises-environment/.
This is probably what you are referring to?
David
dalisaydavid Bingo.
Fantastic. Thank you Anonymous!
Anonymous So that is the trick to use PBI desktop and load into SSRS'16 to keep it all on-premises without using PBI service.
Thanks for the clarity.
But i thought PBI desktop development using direct query & the enterprise gateway with published PBI service dashboards still ensured the data remained on-premises...or is that wrong ?
DavidMoss There are still users that cannot user Power BI (ex.government) in the cloud due to compliance levels of data storage in Azure. You are correct though, when using Direct Query to a database or Live Connection to a cube/model those methods keep the data on premises or in the database of origin.
