Power BI: Setting up Power BI Report Server, Uploading Reports, LAN & Internet Access, & Embedding
DescriptionThe video explains the process of installing and running a Power BI Report Server from a virtual machine. The video recommends running the Report Server from a virtual machine for better security. The video then explains the process of downloading and installing SQL Server Express, which is required to run the Power BI Report Server.
The video shows how to download and install SQL Server Management Studio (SSMS), which is recommended but not required to run the Power BI Report Server. The video then explains how to download and install Power BI Report Server from the Microsoft website.
The video then shows how to set up the Power BI Report Server using the Report Server Configuration Manager. The video explains how to connect to a report server, set up the virtual directory, set the IP address and port number, and create a new database. The video then shows how to test the connection and create the necessary databases in SQL Server Management Studio.
The video then shows how to set up the web portal URL that will be used to access the Power BI reports. The video shows how to upload a Power BI report to the report server using the web portal. The video then shows how to start and stop the report server using the Report Server Configuration Manager.
Finally, the video explains how to make the virtual machine independent of the host computer by changing the virtual machine's network settings. The video shows how to configure the network settings to allow the virtual machine to have its own IP address and be accessible from the internet.
00:42 - Installing SQL Server Express
01:58 - Installing SQL Server Management Studio
03:10 - Installing Power BI Report Server
04:54 - Configuring Power BI Report Server
08:54 - Uploading files to the Power BI Report Server
09:56 - Starting Power BI Report Server again
11:28 - Making necessary Changes to the Virtual Machine
13:22 - Configuring the Report Server to user IP Address
15:45 - Accessing Report Server from another PC on LAN
18:06 - Accessing Report Server from a Mobile Phone on LAN
18:44 - Accessing Report Server from Internet
19:55 - Using Port Forwarding to Connect our Report Server to the Internet
22:22 - Embedding your Report in another Web-page
#PowerBI #ReportServer #VirtualMachine #SQLServer #SSMS #WebPortal #Dashboard #Microsoft #portforwarding #ipaddress #publicip