Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Analyze data In EXCEL POWER BI SERVICE - External/Guest Users

Is there a way to enable external/guest users to analyze data in Excel? That feature that brings the dataset to an Excel sheet.

 

I just shared a report with an external user, and the analyze in Excel is not enabled.

 

 

 

I just read the docummentation and it seems there is no limitation for such.

 

https://docs.microsoft.com/pt-br/power-bi/collaborate-share/service-analyze-in-excel

 

Thanks!

 

General Comment
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi Anonymous 


    Currently as it stands there is no work around for this in PBI

     

    One option is to create an AAS database.

     

    Or you create a local user in your tenant and grant them access this way.

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

     

    If you look under the limitations in your link it does specify that Guest (External) users can't use Analyze in Excel

     

    I hope that clarifies this for you?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks GilbertQ ! Do you know any workaound? Does not make sense Microsoft does not let users guests that were added to azure b2b not be able to analyze the underlying data as datasource.

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        5 years ago

        Hi Anonymous 


        Currently as it stands there is no work around for this in PBI

         

        One option is to create an AAS database.

         

        Or you create a local user in your tenant and grant them access this way.