Forum Discussion

WendyDUFE's avatar
WendyDUFE
Helper III
4 years ago

Export -PowerPoint - Embed Live Data available for B2B guest users ?

Hi ,

 

In my tenant, there are B2B guest user invited, I have power BI premium capacity and share the reports to the B2B guest users via Premium Workspaces.

 

Recently, I noticed that there is a new festure released from Power BI Service, user can select to connect to the live report data from Power Point by clicking the export -> powerpoint menu:

 

Previously, there is only one option "Embed an image" .

 

 

The B2B users can select this option to embed the live data, however, when open the PowerPoint, there is error displayed:

The error details:

 

Http Status Code: 401
Error Code: GroupNotAccessible

Error Time: 2022-07-12T02:47:55.629Z

Cluster URI: https://WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Api URI: https://api.powerbi.com
Build: 13.0.18578.34
Office Host: PowerPoint
Platform: PC
PPT Version: 16.0.15330.20230

 

The B2B user has M365 enterprise subscription in his home tenant and the B2B guest user can embed the live data from the report in his home tenant successfully. 

 

In my tenant there is no M365 subscription.  Is this the problem ? or is the B2B user type a problem ?

 

"Embed an image" works totally fine for all the B2B users. If the "Embed live data " does not work for B2B guest users, I want to check whether this "Embed live data " option can be disabled ? But I still need the "Embed an image"  option enabled.

 

Below is my tenant settings currently, kindly FYI

 

Thank you

 

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi WendyDUFE ,

     

    Thank you for providing such detailed information. Based on your error message, the error appears “GroupNotAccessible“,so I think it may be due to insufficient permission.

    Please check that the account used by PowerPoint has reporting permissions.

     

    You need to be logged in to an account that has permissions to the report on PowerPoint. If the account does not have permission, a 401 code will be returned.

     

    You can also through another way as the following shows to make sure people in your organization can get access.

    For detailed information please refer to this doc : Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint. | Microsoft Power BI Blog | Microsoft Power BI

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • WendyDUFE's avatar
      WendyDUFE
      Helper III

      Anonymous 

       

      Thanks Selina,

       

      I have went through the link you provided, also I double confirmed that the user has the report access from Power BI Portal.

       

      Two Power BI Portal, 

      A is home tenant power bi portal

      B is B2B guest tenant power bi portal (Premium Workspace)

       

      User can export - > powerpoint-> embed live data successfully for case A

      however, even though user can view the report for case B (has access to the report), but encounter the issue

       

      Does the B2B guest user type matter ?

       

      Http Status Code: 401
      Error Code: GroupNotAccessible

       

      Below is my account snapshot

       

      below is the workspace snapshot, you can see it is premium capacity workspace 

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi WendyDUFE ,

       

      It took me a while to think about your question. I was wondering if you have tried embedding the PPT for users in the organization, not guest users, and if it works?


      And I've been thinking about the "GroupNotAccessible" error, do you share reports to guest users by group or by individual user?

       

      Best regards,

      Community Support Team Selina zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

      • WendyDUFE's avatar
        WendyDUFE
        Helper III

        Anonymous  Hi Selina,

         

        The user in the organization do not have the M365 subscription, it does not work .

         

        Report is shared to guest users via Security group (by first inviting users to my organization as B2B guest user).

         

        BTW, If the "Embed live data " does not work for B2B guest users, I want to check whether this "Embed live data " option can be disabled ? But I still need the "Embed an image" option enabled.

    • WendyDUFE's avatar
      WendyDUFE
      Helper III

      I also voted for this idea. But as per the post in the idea thread, it seems this is a powerpoint product limitation, the office / microsoft product license probably can only be activated from the home tenant ... ak-owa 

  • Anonymous's avatar
    Anonymous
    Not applicable

    I was also trying to embed live data into PowerPoint and have a similar issue, but my error code is showing UserNotLicensed. Is it because of the Power BI trial license? I was just trying to embed it into my PPT without sharing to anyone.