Setup On premises Power BI Report Server with MSSQL server enterprise

Understand Power BI and Setup On-premises Power BI Report Server

AGENGA

• Introduction - What is Power BI
• Difference Components of Power BI
• Licence Requirements
• Infrastructure Requirements
• Step by Step Installation

Introduction - What is Power BI

Create amazing data experiences
Easily connect to, model, and visualize your data, creating memorable reports personalized with your KPIs and brand. Get fast, AI-powered answers to your business questions—even when asking with conversational language.

Gain insight from your largest BI deployments
Make the most of your big data investments by connecting to all your data sources with the scale to analyze, share, and promote insights across your organization while maintaining data accuracy, consistency, and security.

Make decisions with confidence
Work together easily on the same data, collaborate on reports, and share insights across popular Microsoft Office applications such as Microsoft Teams and Excel—empowering everyone in your organization to quickly make data-driven decisions that drive strategic actions.

Difference Components of Power BI

Licence Requirements

Infrastructure Requirements

Step by Step Installation

MSSQL Stand-alone Installation

1. Add licence key/select free community edition
2. Accept the term
3. Skip update of Microsoft click on (next)

4. Feature selection

   - select **database engine services**
   - select **SQL server replication**
   - select **client tool connectivity**
   

5. Instance_ID = MSSQLSERVER (default)

6. Server configuration

   - Startup_Type = “ i set all on **Automatic**”
   

7. Database engine configuration

   - **Mixed Mode** = (SQL and windows auth)
   

   • pwd = abcd@12345
   • click “add current user” as SQL server admin
   • user = SERVER\Administrator

8. View the summary click “next”

9. Click “install” (installation_progress)

10. Complete (close)

Install MSSQL Server Management Tools

1. Click to install and you redirect to a web page to download
2. and just click “next” and install.

Install MSSQL Server Reporting Services

1. Click to install and you redirect to a web page to download
2. And just click “next” and install.
3. Setup completed, then click on “configure report server”

4. Report Server Connection

• server_name = MSSQL-REPORT-SERVER
• report_server_instance = SSRS
• and click “connect”

5. Report Server Database

• click to “change database”
• default values are set

• and click “test connection”

  it “ok” because it the same server

   **server name** = __xxxx__
  

  auth type = current user-integration
  username = SERVER\Administrator

click “next”.

**databasename**       = xxxxxxxxx
**temp dbname**        = xxxxxxxxxTempDB
**Report server mode** = Native

• define auth select “ windows credentials”

  **domain\user** = SERVER\Administrator
  

  pwd = abcd@12345

click “next” and then “install”.

6. web service URL

• assign ip

  ip_address= 10.0.0.2
  TCP_port = 80

• click "apply"

  URL= https://10.0.0.2:80/xxxxxx

7. Service Account

• use the same account of windows I used early

  domain\user = SERVER\Administrator
  pwd = abcd@12345

8. web portal URL

URL= https://10.0.0.2:80/xxxxxx

Final Configure with Power BI Report Server

• https://dev.to/syedasadrazadevops/setup-on-premises-power-bi-report-server-with-mssql-server-enterprise-4j5o-temp-slug-5780904?preview=fa3acf7cdae5b4b6067b7de4747d51552d9aea6f183bcba11585b8eb5b79c26eec2301c8a3f850977cc9eefb410c7ae27f365aeb6406b7720de45a71
• https://www.youtube.com/watch?v=iS7WySSELKA&t=1721s
• https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-report-server-service-account-ssrs-configuration-manager?view=sql-server-ver16