Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

New Member

Accessing Power BI report server reports in office 365

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.



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?

Helper II
Helper II

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!



Hari T


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. 

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.