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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
hellodfkh
Frequent Visitor

PowerBI Report Server Deployment advice

Hi Everybody, 

I wanted advice on the deployment setup we are using for a use case we are developing: 

 

- PowerBI Reports need to connect to on premises SQL Server

- These PowerBI reports then need to be accessed over the public internet

 

Current Deployment Setup:

- PowerBI Report Server and PowerBI Destkop (Report Server) on an on premises Windows VM which has access to the on premises SQL Server

I want to understand whether we would need the PowerBI Gateway or connection to the SQL Server might just be done through the PowerBI Report Server? Also, how do I make these reports available in the public domain? Any links to tutorials or docs will be appreciated

 

Thanks. 

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

Hi @hellodfkh ,

1. On-Premises Gateway used for Power BI Service, you need not gateway

2. Please try to use Microsoft Entra application proxy to connect to Power BI Report Server. Through this integration, users who are away from the corporate network can access their Power BI Report Server and Reporting Services reports from their client browsers and be protected by Microsoft Entra ID.

 

For more details, you could read related document: Configure Power BI Report Server with Microsoft Entra application proxy - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

Hi @hellodfkh ,

1. On-Premises Gateway used for Power BI Service, you need not gateway

2. Please try to use Microsoft Entra application proxy to connect to Power BI Report Server. Through this integration, users who are away from the corporate network can access their Power BI Report Server and Reporting Services reports from their client browsers and be protected by Microsoft Entra ID.

 

For more details, you could read related document: Configure Power BI Report Server with Microsoft Entra application proxy - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.