Can users who you share with 'analyze in excel'- Error (Forbidden server)

[Sophielane1]

I'm trying to share a report with people outside my organisation. Everytime they try and ' analyze in excel' or download as a pivot table they get error messages "the http server returned the following error- forbidden server" Or another one- you do now have permissions. 

Is this part of security? Or is there a way for shared users to view pivot tables

[ankitpatira]

@Sophielane1 I don't think analyze in excel is supported with share outside organisation.

[Sophielane1]

@ankitpatira Hi, thanks for the response. Does this change with the pro version? Or is there any other way of sharing downloaded pivots outside the organisation?

[v-yuezhe-msft · Accepted solution]

Hi @Sophielane1,

Based on my test, the Analyze in Excel feature is not available for external users even if they are pro users in Power BI. And for external users, as far as I know, there is no method to download the underlying dataset of a shared report in Excel.

However, there is an idea that make “Analyze in Excel" available for external users through API has been submitted in the following link, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15561135-route-analyze-in-excel-o...

Thanks,
Lydia Zhang

[MacJasem]

@v-yuezhe-msft 

Is there any update on this issue since you posted this message?

I have just run into the same issue, but i have other reports in other workspaces that are share with others outside of my tenant that have the ability to extract an Analyze in Excel report.

I can really see why some of my shared reports have this feature/option enabled and some not..

Can you and anybody else tell me why that might be? is there something that i'm missing?

[Sophielane1]

Hi, thanks for the response. Does this change with the pro version? Or is there any other way of sharing downloaded pivots outside the organisation?