Access the Power BI reports on your on-premises environment

You need to perform the following steps to access the Power BI reports on your on-premises environment. After deploying reports, you also need to configure the data source properties.

Before you Begin:

• Install and configure the Power BI Report Server. For more information about installing the Power BI Report Server, see the Microsoft documentation.

• Install Microsoft Power BI module for Windows PowerShell by using the 'Install-Module -Name MicrosoftPowerBIMgmt' command. For more information about this Microsoft Power BI Cmdlets, see the Microsoft documentation.

• The execution policy of the user must be updated to 'All Signed' by using the following command.

  
  Set-ExecutionPolicy -ExecutionPolicy AllSigned -Scope CurrentUser

  A confirmation message appears, asking if you want to change the execution policy. Select Yes to change the execution policy.

Steps:

1. Copy and paste the executable files, RS.exe and RS.exe.config (if available), from the PowerBI folder (default installation path of Power BI is \Program Files\Microsoft Power BI Report Server\Shared Tools) to a required folder.

2. Open the PowerShell as an Administrator.

3. Navigate to PowerBI folder and run the DeployPowerBI.ps1 file.

   If a prompt appears asking 'Do you want to run software from this untrusted publisher?', select the required option.

4. Provide the following details:

   1. Data Source name

   2. Database name

   3. For Deploy to Cloud?, enter N.

      Another Command Prompt window appears.

5. Provide the following details:

   4. Power BI on-premises Server Name or IP address

   5. Power BI on-premises Server Web Service Virtual Directory

   The reports will be deployed to the desired Report Server.

Configure the data source properties

6. Open the Report Manager URL you configured earlier.

7. Select Reports>>Mobile Operator folder.

   A list of reports appears.

8. Click the More options icon available next to the report (for example, CompletedProcedure), and then click Manage.

   The properties of the report appears.

9. Select the Data sources, change the following in the Connection string box in the Connection section:

   • Data Source: The name of your Database Server

   • Initial Catalog: The name of your Database.

10. Next, in the Credentials section, provide the database connection credential information.

11. Select Test Connection.

    A confirmation message appears.

12. Select Apply to save your changes.

13. Select the Home breadcrumb link to return to the Power BI Report Server main page.

14. Select Reports>>Mobile Operator folder.

    A list of reports appears. Run the report.

15. Repeat steps 2 through 8 to update the data source information in other reports.