Access Power BI reports on your cloud environment

The following are the steps to access Power BI reports on your cloud environment

Before you Begin:

• Install and configure the data sources on data gateway. For more information about installing and configuring the data gateway, 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. Open the PowerShell as an Administrator.

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

3. Provide the following details:

   1. Data Source name

   2. Database name

      Note: Ensure that you provide the same data source and the database name that you provided during the configuration of the data gateway.

   3. For Deploy to Cloud?, enter Y.

      A window appears, asking you to provide your login credentials.

   4. Workspace name: Enter the required workspace name from the list. This list displays the workspaces to which you have access.

      Note: The default workspace name is ‘My Workspace’. If you do not select any workspace name from the list, you will be redirected to ‘My Workspace’.

      The reports will be deployed to the workspace.

4. Sign in to https://app.powerbi.com/ and access the reports.

   You can now access all the reports from the workspace specified in Step 3 (d).

   Note: If you want to change the database information in the reports, then you must repeat the steps to redeploy the Power BI reports.