Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
We have uploaded an Excel file to the Workbooks section of our Power BI Workspace (the section which has Dashboards, Reports, Workbooks). Is it possible to download the workbook as an Excel file, so that the user can update and interact with it on their own computer? Thanks
Solved! Go to Solution.
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
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.
Thanks for your comments.
Annie
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?
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.
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |