anh_kato's avatar
anh_kato
New Member
3 years ago
Status:
New

Power BI Add-In for PowerPoint to work for Guest (External) Users

Currently, the Power BI Add-In functionality in PowerPoint works ONLY if you are a user of the same organization.

Scenario that is not working and would be nice to have:

Example of case, [email protected] publishes power bi report to web and shares the report to [email protected]. and he is a guest user (B2B). Adam can open the report in Power BI (app.powerbi.com). It would also be good to be able to load the URL in the power bi add-in for powerpoint.

power bi

5 Comments

  • anh_kato's avatar
    anh_kato
    New Member
    3 years ago

    Confirmed with Microsoft Support the limitation and details of issue and analysis

    Issue Definition: 

    External user has issue with viewing Power BI report in after adding into Power Point. 

    Analysis and Resolution: 

    While investigating this issue over screen share, we verified that the external user is having the admin access to workspace and dataset. External user is able to view the report in Power BI Service successfully. The issue is only adding Power BI Report into PowerPoint. 

    According to the documentation from Microsoft- https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-powerpoint#considerations-and-limitations under the considerations and limitations section,


    Some reports cannot be exported. These include:

    • If you share a dashboard with someone outside of your organization, and thereby, a user who isn't in your Power BI tenant, that user can't export the shared dashboard's associated reports to PowerPoint. For example, if you're [email protected], you can share with [email protected]. But [email protected] can't export the associated reports to PowerPoint.


     

    Since the export to Power Point option won't work for external user, this functionality is unfortunately a limitation of the product as of now. 

    We can verify that the report works fine if the host tenant user opened the PowerPoint with power bi reported embedded. 

  • anders_grandt's avatar
    anders_grandt
    New Member
    3 years ago

    Thanks for creating this idea. I cannot understand why Microsoft keep missing key functions like this and access from B2B users. It's the same with open in Excel even if that is possible with a "hack".

    Anyway - the devs needs to step up!

  • kim_oestergaard's avatar
    kim_oestergaard
    New Member
    3 years ago

    Reading the article and Microsoft documentation, it is explicitly mentioned that the external users cannot access Dashboards:


    "If you share a dashboard with someone outside of your organization, and thereby, a user who isn't in your Power BI tenant, that user can't export the shared dashboard's associated reports to PowerPoint".


    So, is it ONLY a limitation for Dashboards, and not Report pages or Report pages in an App? This seems unclear.


    Our external users get that "PowerBIEntityNotFound"-error in PowerPoint, but not sure if this due to those limitations or actually something else.


    Regards

    Kim

  • jochenj's avatar
    jochenj
    Advocate III
    7 months ago
    common Microsoft, no status change after 3+ Years? We would also this usecase, the group company provides centrally the PBI-Service and the subsidaries access allready with B2B Guest accounts the PBI Cross tenant by specifiing the CTID(TenantUrl) in the reports, works great. But unfortunately NOT when trying to render the same reports with the PPT ExcelAddin.. That sould be a small code change in the addin to passthrough the CTID (instead of filtering it out) and so support cross-tenant scenario !?

Recent ideas