Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Report Server Issues with HA and NLB

Hello everyone,   I’ve installed Power BI Reporting Services as a scaled out deployment on two servers with the SSRS DB on a HA Always On Cluster. I’ve used a SSL Certificate for a virtual host nam...
ha
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Î have two server, too. But three errors ...

Anonymous's avatar
Anonymous
Not applicable
8 years ago

pbxjtarquino

Now I removed the reoport server database from the ha group. The server runs stable and the logs are fine.

 

But if I pubish a report via the dektop, it gaves me 4 of 5 times a a error with no description. The Error is only on client side.

If I shutdown one report server, everything seems to be working. So I think there is a error or misconfiguration with the NLB.

The publishing via the upload feature from the webinterface works everytime.

 

Does anyone give me some hints what the IT can check? Or are there any best practice?

  • pbx's avatar
    pbx
    Icon for Helper V rankHelper V
    8 years ago

    You may want to add an entry in the host file of each server that points the virual host name to the IP of that server.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I've tried it, but this have no impact.

  • pbx's avatar
    pbx
    Icon for Helper V rankHelper V
    8 years ago

    Would it be possible to turn on diagnositc logging on the client to see if you get any indication of the possible error there? Are you sure there's aboslutly no clue in the server logs about the error? Can you check if your upload sessiosn jumps across servers?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hm.. today i found following error in the logs:

    ReportingServicesService.log

     

    library!DefaultDomain!1040!01/12/2018-12:55:42:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Invalid PBI Configuration, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

  • jtarquino's avatar
    jtarquino
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    That error is unrelated to the PowerBI Reports feature, the configuration mentioned there is for sending a paginated report visual to the PowerBI.com , more details here https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/power-bi-report-server-integration-configuration-manager.

     

    For your problem publishing from the desktop I would recommend to use a network trace fromo the client to validate the errors you are getting from the server when the NLB is enabled 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This is planned for Monday.

    Gut the powerbi Feature for paginated Feature isnt configured.