Forum Discussion
Download to Excel from PowerBI Workspace
Hi annie_12
If you upload an Excel Workbook from your PC you cannot download it and edit it from what I can see.
What you could do, is to have the Excel file stored in OneDrive for Business or OneDrive personal, and then connect to the data in the Power BI Service via OneDrive.
That will then give you the ability to grant permissions to other users via OneDrive, where they can then access the source Excel file, and update as required.Hi annie_12,
You could refer to this article for more detailed description:
Publish to Power BI from Excel 2016
Regards,
Yuliana Gu
Hi annie_12,
You could refer to this article for more detailed description:
Publish to Power BI from Excel 2016
Regards,
Yuliana Gu
Can I edit the permission for view only, not edit and I still can allow the workspace users to download?
- Hi there,
Are you referring to storing the Excel file inside power bi?Hello Gilbert,
Thank you for the quick answer.
No, I am referring to a report in the workspace, previously our users in our workspace were able to hover on the "hamburger menu" or three dots above a PowerBI visual to export data to excel. A change was made at the beginning of July which removed the export to excel feature for our users. Our admins still seem to have access to this feature. We have recently tried changing our permission setting giving users the ability to edit content in powerbi, to test if that removed their ability to export. It had no impact on their experience. We would like to give this ability to users in our workspace without making them admins.
I don't know if someone from Microsoft knows if they did some change in the workspace features?
Thank you.
- Hi there, do some people see the hamburger menu and others do not?
Or is it possible that they removed the Report Header from the reports?