Forum Discussion

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
7 years ago
Solved

Power Bi report server architecture question

Hello,   I have a requirement to install Power BI Report server on a client network within their own firewall.  They have seperate firewall for the app, database and web tier.  Could I be able to i...
POWER BI Reports in web application
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Right, so I would put the front end of Report Server in the web tier and the database in the app/data tier.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Yes, I would refer you to:

 

https://docs.microsoft.com/en-us/sql/sql-server/install/what-s-new-in-sql-server-installation?view=sql-server-2017

 

I've never seen a 3 tier implementation of SSRS. You will likely want to have your web server in the App tier and your data in the Data tier. Most security folks go nuts if you try to wire the web tier and data tier directly or have your data teir in the app tier. Depends on how crazy your security folks are though.

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
7 years ago

Hi Greg,

 

The client system are designed such that, the data and Applciation tier are within the same firewall and  web tier on a different tier.

So if we have the MS SQL database in the data tier and PBI Report Server (windows server) in the app tier. So these both will fall into the first firewall. 
 
Then how are the web tier configured here?  if I open the web portal and try to refresh the report opened outside the firewall? Getting a hole punched through the firewall will be a question here and not sure if that will be agreed?
 
Thanks,
Rohith
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Right, so I would put the front end of Report Server in the web tier and the database in the app/data tier.