Accessing Power BI report server reports in office 365

[chsandeep25]

Good Day All,

I am fairly new to report server and have a few questions to address one of the requirements we are trying to develop.

Scenario:

We have installed SQL Server on AWS and have Power BI Premiuim license along with it.

We also have an office 365 business premiuim subscription without power BI Pro.

The requirement is to build Power BI reports from the SQL server and allow it for access to users who are using Sharepoint Modern sites via office 365.

I would like to know what is the best way to implement a solution. 

Also, we would like to filter the reports directly from office 365 based on theURL the user is accessing the report from.

I have the following questions:

1. Can we use the existing Power BI premiuim license to enable access to all the users of the company from office 365 SharePoint Online?

2. Do we need to purchase the Power BI Pro license per user in office 365 and then connect to the SQL server database in AWS to build reports?

3. If option 1 is possible, can i have some guidance or links to understand how this can be achieved? 

4. If option 1 is possible, is there a way to filter the reports dynamically based on the SharePoint Online URL?

[harikishant]

You might need to create a custom page in your sharepoint portal and embed the PowerBI into the page. You don't need to have a pro license for this.

Hope this helps!

Cheers,

Hari T

[Jon-Heide]

I'm not a licensing expert. But in general, if you have licensed the PBIRS cores from premium, you do not need to license consumers/viewers. Pro licenses are needed for anyone authoring content to share. Probably best to review these with your sales contatct or account manager.