Setup On premises Power BI Report Server with MSSQL server enterprise
Tags: powerbiserver, mssqlserver, onpremises, powerbi
Published: 2022-11-17 14:04:28

## 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.

![POWER BI](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q6tzncwxnb7twrrlagyi.png)

### Difference Components of Power BI

 ![Components](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ewn1qlmt6utyaj557ikf.png)

### Licence Requirements

![Licence](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hk2ctnh1aw5i0fqx0qym.png)

### Infrastructure Requirements

![Requirements](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gdx514y1wu6du548dif3.png)

### Step by Step Installation

![steps](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mg6t4x03icebj5oix0gy.png)

### **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	

7. View the summary click “next”
8. Click “install” (installation_progress)
9. 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.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/s7w9i9sao9wj4m5qwk1u.png)


### **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


![install and connect power bi server](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ir1j4ugpetwc8jne5nc9.png)






![SSRS=PBIRS](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3j1ed6zz2gzt4d9x6ufl.png)





![REPORT VIEW](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/c8vbgluqqr69chbrzmqh.png)







![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kiwjw39g0xik80qddoxz.png)


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/70ffz93fuy2krdexc8we.png)

- 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