Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Embed Reports in Sharepoint

  • 1.  Embed Reports in Sharepoint

    Posted Jul 25, 2019 10:02 AM
    ​Hi

    Do I  need to be Power BI Pro User to see an embedded Power Bi report in SharePoint, or will this work if I have an Office 365 licence?

    Regards
    Phil

    ------------------------------
    Phil Bell
    IT Consultant
    07957861351
    ------------------------------


  • 2.  RE: Embed Reports in Sharepoint

    Bronze Contributor
    Posted Jul 25, 2019 10:17 AM
    I'm fairly confident you will need a license. My company currently uses the Power BI Report server which can host on prem PBIX reports as well as SSRS. There is a license required for that as well but they do have an evaluation version you can install that lasts 180 days. As for SharePoint I believe you would need to host the PBIX on the web version of Power BI. I could be wrong as we do not embed into sharepoint as we keep everything on prem.

    ------------------------------
    Michael Foss
    Functional/Business Systems Analyst
    ------------------------------



  • 3.  RE: Embed Reports in Sharepoint

    Bronze Contributor
    Posted Jul 26, 2019 03:08 AM
    Hi

    Yes, you need a pro license unfortunately!

    ------------------------------
    Martin O'Connell
    BI Consultant
    ------------------------------



  • 4.  RE: Embed Reports in Sharepoint

    Gold Contributor
    Posted Jul 26, 2019 03:52 AM
    Hi Phil,

    Here is a helpful resource on that subject
    https://powerbi.microsoft.com/en-us/blog/integrate-power-bi-reports-in-sharepoint-online/

    ------------------------------
    David Gerard
    Buisness Intelligence Consultant
    Kampala
    ------------------------------



  • 5.  RE: Embed Reports in Sharepoint

    Silver Contributor
    Posted Jul 26, 2019 06:57 AM
    two work arounds depending on sensitivity,

    1. You can publish the report to MS public workspace, which then allows anyone and everyone in the world to see your report.

    2. Subscribe to the report and then using flow you can save the image you get in your email everyday to a folder in sharepoint, and then you can embed that image in a sharepoint page. This is a great option if it's a static report that doesn't really require any interactivity



    ------------------------------
    Sam Duval
    Data Quality Analyst
    Indianapolis
    ------------------------------



  • 6.  RE: Embed Reports in Sharepoint

    Bronze Contributor
    Posted Aug 13, 2019 02:57 PM
    I have found that I can use the "Publish to Web" option in app.powerbi.com and embed the generated <iframe> code in a SharePoint page. This allows my SharePoint users to view the reports without a PowerBI license.
    I am now trying to wrap my head around how/if these embedded reports automatically update when the underlying data (Excel table stored in SharePoint) is updated. Any help with this would be appreciated.
    Pete Hay
    BI Report Developer

    ------------------------------
    Pete Hay
    BI Report Developer
    5034457155
    ------------------------------



  • 7.  RE: Embed Reports in Sharepoint

    Top Contributor
    Posted Aug 16, 2019 05:04 AM
    Hi @Pete Hay​,

    The reports in the iframe codes will be updated. However, it will take a couple of hours for the report to be updated, once the dataset in the service has been updated. It will NOT be instant, like we have it on the service.
    You will need to setup a gateway for the dataset to be updated automatically, or you can work on the same file, manually refresh the report on PBI Desktop and publish to the service again.

    A gateway would be the best way to go.

    Hope this helps.

    Thank you,

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------



  • 8.  RE: Embed Reports in Sharepoint

    Bronze Contributor
    Posted Jul 26, 2019 01:09 PM

    The short answer is a license is required, but there are two ways to license Power BI embedded content with SharePoint:

       1. Every user viewing the report in SharePoint has a Power BI Pro license

       2. The workspace the report is in, is backed by premium capacity.

    For more details - https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo



    ------------------------------
    Cheers,
    Mike
    ------------------------------