The end user can save a Power BI report created in the Power BI Service in their own Personal Workspace but then they have no way to share it with their team. It remains a personal report/analysis.
When executing the analysis in Excel, they can distribute the Excel-file as they see fit.
The pitfall of personal workspaces in Power BI, from my point of view, is that if someone leaves the company, there isn’t a straight forward way for other end users to take-over previously created analysis.
This is where the Power BI Administrator can be of importance.
Read on to see how a Power BI Administrator can gain access to a personal workspace and migrate reports out of it.