Forum Discussion
Export data to Excel not working in Report Server
We're probably going to wait for the next release. I can't find the link, but I think I read somewhere that they were shooting for Q4 2017. I did find the links below describing a release timeline of about three times a year. If we're counting supported releases (June 2017) and not preview (August 2017), that suggests we may be due for a release sometime in maybe October/November? I'm just guessing.
https://powerbi.microsoft.com/en-us/documentation/reportserver-support-timeline/
As far as workarounds, I've only thought about some ideas, but have not actually done any of this:
- Create an Excel workbook containing a pivot table connected to your SSAS database. Users would have to build the table they want through the pivot table UI.
- Create a paginated report (old SSRS report) with a matrix on it. I suspect these can accept a parameter from a dashboard filter, but haven't checked. These will have an export option to send results to formats like PDF or Excel, but the Excel format might have merged cells and extra rows and columns in an attempt to preserve the report appearance.
- From what I can tell, the site runs self-hosted in its own executable rather than running in IIS where there might be a /scripts directory of some sort where you could copy the missing file, but you could potentially set up IIS or another web server as a reverse proxy to PBIRS for all requests except the filesaver.min.js which you serve directly.
- Client-side? While you can embed a dashboard on another site (https://www.kasperonbi.com/embedding-power-bi-reports-with-power-bi-report-server/), security restrictions would probably prevent you from forcing it to load filesaver.min.js from a CDN. Maybe if there was a custom visual that also loaded filesaver.min.js, it might make it available to the whole dashboard?
Hi all,
Just to provide an update on this - we are tracking the bug and will have this fixed for the production release of the next update of PBI RS this fall. This isn't too far off, so we won't be issuing a fix for this until that time.
Thanks,
Chris
- dataviznz8 years agoAdvocate IV
Can someone please confirm that "Export Data" from a visual through the browser is possible in PBIRS October '17 GA?
- Anonymous8 years agoNot applicable
yes, I can also confirm it is working ok in latest release.
- dataviznz8 years agoAdvocate IV
Not fixed in all cases?
https://community.powerbi.com/t5/Report-Server/Export-Data-button-not-doing-anything/td-p/299441