Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
henry24007
Helper I
Helper I

questions about excel uploading and printing format

1. I would like to know can I download the xlsx excel file from my workspace? Because I cannot find any bottom to download the excel file I have uploaded to power BI service.

 

2. Can I make a bottom or if there is any way to generate different printing report format without making a new report or dashboard?let say I want to have a bottom embedded into the powerbi report that can generate a designed excel report

 

Thanks.

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @henry24007 ,

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.

 

refer:

https://community.powerbi.com/t5/Service/Download-to-Excel-from-PowerBI-Workspace/td-p/212650 

 

Regarding the second point, in my opinion, there is no way to do it. The most convenient is still to download departmental templates online, then according to the templates, import your own data and create reports before publishing them.

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @henry24007 ,

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.

 

refer:

https://community.powerbi.com/t5/Service/Download-to-Excel-from-PowerBI-Workspace/td-p/212650 

 

Regarding the second point, in my opinion, there is no way to do it. The most convenient is still to download departmental templates online, then according to the templates, import your own data and create reports before publishing them.

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

collinq
Super User
Super User

Hi @henry24007 ,

 

There is not a button by default.  To export data from some visuals in the service select the elipses in the top right corner and then select "export data" like this:

collinq_0-1655519206240.png

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors