Forum Discussion

JulesE's avatar
JulesE
Frequent Visitor
6 years ago

PowerBI Report Server - The request failed with HTTP status 401: Unauthorized

I have 2 PowerBI Report Server installed in a scale-out deployment with a network load balancer. I followed the instructions described in https://docs.microsoft.com/en-us/sql/reporting-services/repor...
nlb
PowerBI Report Server
scale-out
flopi's avatar
flopi
Advocate I
6 years ago

Hi,

I had that one and I don't remember the exact solution order, but you must make sure that follwing is done

  •  generate machinekeys and put them in both rsconfig & machine.config. Then restart both nodes
  •  SSL -Offloading must be done by the loadbalancer e.g. F5. The windows networt balancer would never work. I tried it and had to switch to F5
  •  the BackConnectionHostNames entries must be existing on both nodes for the servername only, fqdn, ssrs main page
  • activate session persistance on the load balancer

You are getting 400 because the loadbalancer directs your request to opposite node from which it has been initiated

 

BR Bobi

  • JulesE's avatar
    JulesE
    Frequent Visitor
    6 years ago

    FYI: The place where the machine key should be added to machine.config:

    https://stackoverflow.com/questions/10337634/adding-machinekey-to-machine-config/10337791

    flopi wrote:

    Hi,

    I had that one and I don't remember the exact solution order, but you must make sure that follwing is done

    •  generate machinekeys and put them in both rsconfig & machine.config. Then restart both nodes
    •  SSL -Offloading must be done by the loadbalancer e.g. F5. The windows networt balancer would never work. I tried it and had to switch to F5
    •  the BackConnectionHostNames entries must be existing on both nodes for the servername only, fqdn, ssrs main page
    • activate session persistance on the load balancer

    You are getting 400 because the loadbalancer directs your request to opposite node from which it has been initiated

     

    BR Bobi

     

  • JulesE's avatar
    JulesE
    Frequent Visitor
    6 years ago

    I followed your tips (thanks for that!), but still face with the same problems.

    I can upload files, but only pbix files are failing.

    I have upgraded the report server to the september 2019 release and install powerbi desktop for reporting services, also the september 2019 release, create a simple report, but still cannot upload the report to the report server or save the report to the report server from powerbi desktop. 

     

    So when i upload, as example, a .txt file the upload succeed.

    When i upload a pbix file (created with powerbi desktop september 2019 release) the portal.log show:

    2019-09-30 19:20:56.4850|ERROR|81|The remote server returned an error: (400) Bad Request.| RequestID = s_80a52eb0-89f1-4b6e-87a9-d6b799d09028

     

    I'm confused to can upload everything excepts pbix files.