Setup Power BI Web App

The Power BI service (SaaS) and the Power BI Embedded service in Azure (PaaS) have APIs for embedding your dashboards and reports.

To call these Power BI API’s requires you to create Power BI Web application.

Follow the steps below to register a new application.

  1. Navigate to https://dev.powerbi.com/apps and sign in as a Power BI/Azure administrator.

     

    step-1-power-bi

  2. Specify any App Name.
    1. For App Type, select “Native app
    2. For Redirect URL, put the URL of your Portal Site.

     

    step-2-power-bi

  3. In ‘Choose APIs to access’ section, select “Read All Dashboards” and “Read All Reports” for API permissions.

     

    step-3-power-bi

  4. Then register your app by clicking on “Register App” button. Note the Client ID.

     

    step-4-power-bi


Note: Make sure your account has the required permission to access the application.

Follow the steps below to grant permission:

  1. Log in to the Azure Portal https://portal.azure.com as Azure administrator.
  2. Click on ‘All Services’ in the left panel and search for “App registrations”.
  3. Click on ‘App registrations’ and select the respective app which you want to display in The Portal Connector.
  4. The Power BI Web App window will open, click on ‘Settings’. From the Setting panel, click on ‘Required Permission’ under API access section.
  5. Now in the Required Permission window, click on “Grant Permission”.

 

permission

 

To display reports in The Portal Connector using Power BI Web app, you would need to configure the application in The Portal Connector as follows:

  1. Navigate to the Sitefinity backend
  2. Go to Administration > Settings > Advanced > PortalConnectorMvcPowerBI > Application Configurations
  3. Click Create New
  4. Fill in the information, the App Name here does not have to match your App Name configured previously
    1. The username and password should be for a user that has access to view all the reports/dashboards you want to view

 

settings