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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.