Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

PowerBI vs SSRS Licensing

I have two different clients who are both asking the same question.  With the new release of SSRS, and the new PowerBI Server…it appears that users will be able to publish PowerBI reports into SSRS a...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

    Summary of the Power BI Integration and Pin Process

    This sections summarizes the basic steps and technologies involved when you integrate your report server with Power BI and pin a report item to a dashboard.

    Integrate:

    1. In Configuration manager, when you select the Register with Power BI button, you will be prompted to sign in to Azure Active Directory.

    2. The Power BI Client App is registered with your managed Tenant.

    3. Your managed tenant within Azure Active Directory is where the Power BI Client app is created.

    4. The registration includes a redirect URL(s) that are used when users sign in from the report server. The App ID and URLS are saved to the ReportServer database. The redirect URL is used during authentication calls to Azure so that the call can return to the report server. For example, when users sign in or pin items to a dashboard..

    5. The App ID and URLS are displayed in Configuration Manager.

      ssrs_pbiflow_integration

      When a user pins a report item to a dashboard:

    6. Users preview reports in the Reporting Services web portal and the first time they click to pin a report item from the web portal.

    7. They will be redirected to the Azure AD sign-in page. They can also sign in from the web portal My Settings page. When users sign in to the Azure managed tenant, a relationship is established between their Azure account and the Reporting Services permissions. For more information, see My Settings for Power BI Integration (web portal).

    8. A user security token is returned to the report server.

    9. The user security token is saved to the ReportServer database.

    10. A list of groups, and dashboards, the user has access to are retrieved from the Power BI service. The user selects the destination group, and dashboard, and the configure how often they want the data refreshed on the Power BI tile.

    11. The report item is pinned to the dashboard.

    12. A Reporting Services subscription is created to manage the scheduled refresh of the report item to the dashboard tile. The subscription uses the security token that was created when the user signed in.

      NOTE: The token is good for 90 days, after which users need to sign in again to create a new user token. When the token is expired, the pinned tiles will still be displayed on the dashboard but the data will no longer be refreshed. The Reporting Services subscriptions used for the pinned items will error until a new user token is created. See My Settings for Power BI Integration (web portal). for more information.

    The second time a user pins an item, the steps 1-4 are skipped and instead the App id and URLS are retrieved from the ReportServer database and the flow continues with step 5.

    ssRS-pin-to-powerbi-flow


    For more details about Power BI and SSRS Report Server Integration, you can refer to this article. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Anonymous,

Summary of the Power BI Integration and Pin Process

This sections summarizes the basic steps and technologies involved when you integrate your report server with Power BI and pin a report item to a dashboard.

Integrate:

  1. In Configuration manager, when you select the Register with Power BI button, you will be prompted to sign in to Azure Active Directory.

  2. The Power BI Client App is registered with your managed Tenant.

  3. Your managed tenant within Azure Active Directory is where the Power BI Client app is created.

  4. The registration includes a redirect URL(s) that are used when users sign in from the report server. The App ID and URLS are saved to the ReportServer database. The redirect URL is used during authentication calls to Azure so that the call can return to the report server. For example, when users sign in or pin items to a dashboard..

  5. The App ID and URLS are displayed in Configuration Manager.

    ssrs_pbiflow_integration

    When a user pins a report item to a dashboard:

  6. Users preview reports in the Reporting Services web portal and the first time they click to pin a report item from the web portal.

  7. They will be redirected to the Azure AD sign-in page. They can also sign in from the web portal My Settings page. When users sign in to the Azure managed tenant, a relationship is established between their Azure account and the Reporting Services permissions. For more information, see My Settings for Power BI Integration (web portal).

  8. A user security token is returned to the report server.

  9. The user security token is saved to the ReportServer database.

  10. A list of groups, and dashboards, the user has access to are retrieved from the Power BI service. The user selects the destination group, and dashboard, and the configure how often they want the data refreshed on the Power BI tile.

  11. The report item is pinned to the dashboard.

  12. A Reporting Services subscription is created to manage the scheduled refresh of the report item to the dashboard tile. The subscription uses the security token that was created when the user signed in.

    NOTE: The token is good for 90 days, after which users need to sign in again to create a new user token. When the token is expired, the pinned tiles will still be displayed on the dashboard but the data will no longer be refreshed. The Reporting Services subscriptions used for the pinned items will error until a new user token is created. See My Settings for Power BI Integration (web portal). for more information.

The second time a user pins an item, the steps 1-4 are skipped and instead the App id and URLS are retrieved from the ReportServer database and the flow continues with step 5.

ssRS-pin-to-powerbi-flow


For more details about Power BI and SSRS Report Server Integration, you can refer to this article. :smileyhappy:

 

Regards