Forum Discussion
Sharing Analyze in Excel - External
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.
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:
-
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.
-
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.
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?
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.