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...
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