Forum Discussion

nathandunlapWTW's avatar
nathandunlapWTW
Frequent Visitor
9 years ago

Export data to Excel not working in Report Server

My colleague and I successfully connected my DB to Analysis Servers and then a PBI Report Server (August version). Everything looks great, but nothing happens when I try to export the data from a vis...
MikeHNJ's avatar
MikeHNJ
Frequent Visitor
9 years ago

 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? 

 

 

Ramzivic's avatar
Ramzivic
New Member
8 years ago

Hi,

I found a workaround for this issue by intsalling quickly ARR role on my Power Bi Server. In my ARR I configured a farm containing just one static server where I put the filesaver.min.js file. A rewrite rule is created to redirect all requests containing filesaver.min.js to the backend Farm. It s working as a charm for me and I could export to csv files. Hope it helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi, can you explain this in more detail - I might be being a little thick here but what is the ARR role?

    • MikeHNJ's avatar
      MikeHNJ
      Frequent Visitor
      8 years ago

       

      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.

    • Ramzivic's avatar
      Ramzivic
      New Member
      8 years ago

      Anonymous, 

       

      Perhaps, I will write someting on the solution. So stay tuned! 

      • sevenhills's avatar
        sevenhills
        Super User
        8 years ago

        Does anyone has a solution? Post the steps to resolve the issue, pls. Thanks