Power BI has become the go to BI tool for organizations that are already using SharePoint and Office 365. That said, there is often some confusion as it relates to how to embed Power BI reports into SharePoint. This is somewhat dependent on your license model. If you have a mix of Power BI Pro licenses and users without pro licenses, you will have to use a script editor web part to embed the report into a SharePoint page, you can not use the Power BI web part in SharePoint. In addition, if you are using Row Level Security in Power BI, this won’t work for non Power BI pro users.
For those of you looking to use Row Level Security with non Power BI pro users, you will have to control permissions from the SharePoint side of things.
If you are looking to discuss Power BI or SharePoint, please feel free to reach out to us by phone at 212-997-9444 or via email