Forum Discussion
Helper IIIPower BI and Power Pivot
Hi All - not sure if this is the right forum
I have an Excel report using Power Pivot and a pivot table on top of that.
I can upload this to the Power BI service and you can play with it just fine.
My issue is I can't download the file. I need to allow users to grab this report and download it. I put it up in Power BI so I can refresh it on a schedule.
Am I missing a feature to be able to download this workbook? I can't even edit it or download it and it's my workbook.
Thanks!
Cathryn
To enable Edit, you need to save your workbook to OneDrive, delete the original one in Power BI Service, and upload from the OneDrive Excel file again.
Best Regards,
HerbertThat worked! Now I just hope the user can download the workbook. I shared the dashboard
In this scenario, your colleagues can view the tiles without needing permissions for the workbook itself.
Only when clicking the tile, opens the workbook inside of Power BI. The workbook will only open if your colleagues have at least read permissions to the workbook on OneDrive for Business.
For details, please refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-service-share-dashboard-that-links-to-excel/.
Best Regards,
Herbert
8 Replies
v-haibl-msftMicrosoft Employee
Now we can only download a report (.pbix file) from Power BI service to Desktop, or export data from Power BI visualizations as a .csv/.xlsx file. But cannot download the excel report which uploaded to Power BI Service.
If the excel report is under Workspaces - Workbooks, you can try to edit in Excel/Excel Online and then save/download it through Excel App.
Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-to-pbix/
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/
Best Regards,
Herbert
CathrynThank you for the reply
Edit is greyed out even though it's my workbook. So, I was wondering if it's because it's a PowerPivot vs just a regular spreadsheet with a data connection
Cathryn- v-haibl-msft
To enable Edit, you need to save your workbook to OneDrive, delete the original one in Power BI Service, and upload from the OneDrive Excel file again.
Best Regards,
Herbert