Sharing Analyze in Excel - External

[ChristianDGreat]

It seems sharing "Analyze in Excel" is currently a limitation. Is there any other solution for this? Right now, we have external accounts invited as guests in our tenant, and we can share Power BI reports in the service (online), but sometimes there are cases where they want to connect to the data via Excel.

Is there an alternative solution to this? Maybe a Fabric capability I'm not aware of, like XMLA Endpoint (I'm not familiar with this)?

I just want to know the options so I can research and focus on them.

[v-zhangtin-msft]

Hi, @ChristianDGreat 

Sharing "Analyze in Excel" can indeed be a limitation, especially when working with external accounts and guests in your tenant. However, there are a few alternative solutions you might consider:

1. Power BI Service: You can use Power BI reports in the service (online) to share data with external accounts. This allows for interactive data exploration and visualization without the need for Excel.

2. Export to Excel with Live Connection: This feature in Power BI allows you to create Excel workbooks containing connected Power BI data that you can refresh directly inside the workbook. This ensures that you're working with up-to-date data. However, it's important to note that this method doesn't support datasets over 1.5 million cells and might require a Power BI license.

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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

[ChristianDGreat]

We are currently using Power BI already to present them data.

But wanted to explore how we can give them connection via excel specially for analyst that wants to do more adhoc on Excel?

Is there still a way? even in fabric? or the only way is to give them Internal Accounts?

[v-zhangtin-msft · Accepted solution]

Hi, @ChristianDGreat 

There's no better way to do it for now. Can only give internal accounts.

Best Regards,

Community Support Team _Charlotte

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