User Profile
MikeHNJ
Frequent Visitor
Joined 8 years ago
User Widgets
Contributions
Re: Export data to Excel not working in Report Server
Thanks, Ramzivic. Anonymous wrote: Hi, can you explain this in more detail - I might be being a little thick here but what is the ARR role? ARR = Application Request Routing, part of IIS. See Using the Application Request Routing Module and Define and Configure an Application Request Routing Server Farm. Essentially, this is an implementation of that reverse proxy approach where you've got a middleman web server that forwards requests for everything except the missing filesaver.min.js file on to the PBIRS web server.Re: 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://community.powerbi.com/t5/Report-Server/Power-BI-Desktop-for-Report-Server-Release-schedule/td-p/219494 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?Re: Export data to Excel not working in Report Server
Just to add a little detail we're using Power BI Report Server, August 2017 Preview. On visualizations like Table, the Export Data feature is not working when viewing a Power BI report in the browser. THe option is available on the menu in the upper-right corner, but nothing happens when you click it. Capturing network traffic in the browser's Developer Tools shows that the browser (this is seen in both IE 11 and Chrome) makes a request for http://powerbiservername/14.0.600.379/externals/filesaver.min.js when you click Export Data, but it receives a 404 (Not Found) response in reply. An Error is also shown in the console: message: "Script error for "filesaver" http://requirejs.org/docs/errors.html#scripterror" Is there a workaround? It looks like all the resources (script, css, etc.) are compiled into DLLs, but is there any way to manually copy the missing filesaver.min.js somewhere and have the web server find it?
