If you have been using Power BI and think about how you can host your report locally, good news is you will be able to do so very soon. Microsoft released technical preview for on premise hosting of power BI reports inside SSRS. Below link is the official guide from Microsoft on how you can actually do this. I won’t repeat here on the how’s, but I would like to call out a few things that might still confuse you.
1 It’s still beta version and the only supported data source for your Power BI reports at the moment is SQL server analysis service and you have to use direct query. That’s right, live connection to your SSAS cube (either multi dimensional or tabular) instead of loading data from cube to your Power BI data model. Microsoft is planning to add more data source in the future.
2 You may wonder why live connection? Because to make SSRS integrate with Power Query seamlessly is not an easy thing and Microsoft needs time to deliver this. So at the moment, only live connection to your cube.
3 Microsoft is targeting mid 2017 to release the GA and the licensing details won’t be available until close to that time. so sit tight and it’s coming.
Now without further ado, go try out the preview feature on your local server or VM.