Power BI is, to some degree, like Microsoft took all the PowerPivot/tabular tools out of Excel and put them in a standalone application. You can use it for data modeling, lightweight integration, and then presentation (the reports). And if you get a really complex system, you can upgrade it to SSAS tabular... which you would need if you wanted data security.